INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

restore db

restore db

(OP)
Greetings,

For some unknown reasons, the shared folder where the ms access db is stored disappeared. The IT department was able to restore the db. Since the restore, when users click the ‘attachment’ button they no longer see the folder where the attachments are stored. Instead, ‘My documents’ window appears.

I checked the code to verify the path to the attachment location is correct.
I did compact & repair, and performed link table manager.

Is there any place I need to check?

TIA

Regards,

OCM

RE: restore db

Sounds like corruption. I am assuming you have looked at the code and it isn't something simple like some test that is different in a different situation.

There is the decompile command line switch. It removes compiled code that compact/repair won't clean up. If it is corrupt, bad happens... Below is an example using Access 2013 32 bit on 64bit machine... basically find your correct path. I often put this in a shortcut but batch file or run should also work fine.

"C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.exe" "DatabasePathAndFile" /decompile

Continuing down the list if it is still broke...

Next try creating a new file and importing everything into it.

Next...

There are also two undocumented procedures. That take object constants similar to docmd.close...

The example below would save a form to text file and load it from text file... I would save to text from the corrupt database, import the other 'good' objects and then load the bad object from text. In theory you could do this for all your objects to have the best chance of recovery. Do not save links, just recreate them.

CODE

SaveAsText acForm, "FormName", "C:\temp.txt"
LoadfromText acForm, "FormName", "C:\temp.txt" 

Next try an earlier backup or recreate the object manually.

RE: restore db

It is possible that IT did not put back the correct permissions on the folder so you can see it and your users might not...

Simi

RE: restore db

(OP)
lameid/Simi,

Thank you both for your reply post and helpful suggestions.
The attachment is now working. Apparently, the IT department recovered the wrong version of the DB.

Regards,

OCM

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close