I'm not able to open my secured database

[Guest]

Hi,

I have an Access-2000 database that I secured using the security wizard. I
used the option to create a shortcut. I then set up my own users and groups.
The database has worked fine for almost a year. All of a sudden, I tried to
open it and got the "Microsoft Access has encountered an error and needs to
close." dialog. I checked the shortcut properties and the path strings are
correct. If I use shift-bypass to open the file after entering my user name
and password, the database opens, I can see all the objects, but after about
10 seconds, I get the same error dialog. During one of these 10-sec
intervals, I tried to quickly compact and repair the database, but the dialog
comes up and the database has to close. Next, I pointed the shortcut to one
of the db backup copies that gets created when that error dialog closes, but
had the same results. Does anyone know what's going on here? Is there any
way for me to connect to this database and import all the objects to a blank
database?

Thanks,

Jeff

 

[Rick Brandt]

Hi,

I have an Access-2000 database that I secured using the security
wizard. I used the option to create a shortcut. I then set up my
own users and groups. The database has worked fine for almost a year.
All of a sudden, I tried to open it and got the "Microsoft Access has
encountered an error and needs to close." dialog. I checked the
shortcut properties and the path strings are correct. If I use
shift-bypass to open the file after entering my user name and
password, the database opens, I can see all the objects, but after
about 10 seconds, I get the same error dialog. During one of these
10-sec intervals, I tried to quickly compact and repair the database,
but the dialog comes up and the database has to close. Next, I
pointed the shortcut to one of the db backup copies that gets created
when that error dialog closes, but had the same results. Does anyone
know what's going on here? Is there any way for me to connect to
this database and import all the objects to a blank database?

Thanks,

Jeff

Thias really has nothing to do with security. Your file is just corrupted.

Make a copy of your shortcut and in the copy remove the path to the MDB
file. That new shortcut will then open Access with your secured workgroup
without opening your corrupted file. From there you might be able to do a
compact and repair on the file. If that won't work then you can at least
from that position create a new blank file and try to import all of the
objects. You will lose all your permissions settings doing that, but it
might get you going again.

 

[Joan Wild]

Hi,

I have an Access-2000 database that I secured using the security wizard.

The 2000 wizard is flawed, so your database is likely not secured properly.

I
used the option to create a shortcut. I then set up my own users and
groups.
The database has worked fine for almost a year. All of a sudden, I tried
to
open it and got the "Microsoft Access has encountered an error and needs
to
close." dialog. I checked the shortcut properties and the path strings
are
correct. If I use shift-bypass to open the file after entering my user
name
and password, the database opens, I can see all the objects, but after
about
10 seconds, I get the same error dialog. During one of these 10-sec
intervals, I tried to quickly compact and repair the database, but the
dialog
comes up and the database has to close.

Backup the database. Modify your (or create a new) shortcut that includes
the /wrkgrp switch and path to the secure mdw but no path to the mdb.

"path to msaccess.exe" /wrkgrp "path to secure.mdw"

Use Tools, Database Utilities, Compact - this will prompt you for the source
file and a destination file.

If that fails, try using Jetcomp available from
http://support.microsoft.com/?id=273956

If that fails, try the shortcut above, create a new mdb, and import all the
objects from your mdb. Note that the imported objects will not have any of
the permissions you had in your old mdb - you'll need to reset them. Once
you import, hit Ctrl-G, Debug menu, Compile and then Save. Follow that with
a compact of the database.

 

[Guest]

Thanks for the quick response guys. I'll

 

[Guest]

Thanks Rick. That worked. I was able to open the database and the do a c&r.