Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Access 97 read permission

Access 97 DB lost Read permision while compacting on a shared drive.

DB won't open.  No security setting were present before.

I can start new DB, do file get external link, and see the names of the tables, but when you select link, the new DB throws the same error.

Is there a workaround for this?

Thank you
0
tonyraymond
Asked:
tonyraymond
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What's the exact error you get?

Have you tried Jet Comp? It's available from MS (link on my page: www.thedatabaseplace.net\dataupdates.asp). Also, check the share folder for a stray .ldb file (the filename will be the same as the dbname, except with an .ldb extension). If you find the .ldb file, delete it (Access will rebuild it as needed).

If JetComp won't do it, then it may be time to rebuild from backup ...

And, do NOT compact/repair via a shared drive ... go to the machine housing the db and compact from there, or setup a utility that will do it for you (JetComp can be run via the Scheduler, for example, or you can install JetComp on the "server" and run it ON THE SERVER from your workstation) ... compacting over the network is just asking for trouble, as you see
0
 
namliam_ehtCommented:
Make sure you have read and write permissions on the folder of the DB...

Greetz
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now