Error accessing file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get an error of "Error accessing file. Network
connection may have been lost." whenever I try to open a
Report/Form with a module. I imported some forms from
another database. I've research this error and know why I
get it, but I don't know how to fix it. I've re-installed
access and downloaded the latest Office security patch
(SP3) which is suppose to resolve this kind of issue.
However it hasn't resolved it for this one database. This
database is a secure database so I can't just import the
objects into a new database, it won't bring in the
security with the objects. I don't want to have to
recreate the security file if I don't have to. Has anyone
out there had this same situation. If so, how did you
resolve it? My goal is to keep the database without
having to create a new one and resolving the problem
within it.
 
I get an error of "Error accessing file. Network
connection may have been lost." whenever I try to open a
Report/Form with a module. I imported some forms from
another database. I've research this error and know why I
get it, but I don't know how to fix it. I've re-installed
access and downloaded the latest Office security patch
(SP3) which is suppose to resolve this kind of issue.
However it hasn't resolved it for this one database. This
database is a secure database so I can't just import the
objects into a new database, it won't bring in the
security with the objects. I don't want to have to
recreate the security file if I don't have to. Has anyone
out there had this same situation. If so, how did you
resolve it? My goal is to keep the database without
having to create a new one and resolving the problem
within it.
Click to expand...

Unfortunately, as KB article 304548 explains, the SP3 service pack
doesn't fix the corruption that has already occurred; it just keeps it
from happening again. You could *try* decompiling the database using
the /decompile command-line switch, but I don't know if that will work.
I haven't heard of any other solution than to import all the non-corrupt
objects into a new database. However, you can probably run code to copy
the permissions of all the imported objects from their originals.

Sandra Daigle has posted a dbUtilities module that is designed to copy
permissions from one database to another with similar structure. You
might want to have a look at it:

http://www.daiglenet.com/MSAccess.htm
 
Back
Top