I'm not able to open my secured database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Stroope - 04 Apr 2007 18:36 GMT

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

Signature

Thanks,

Jeff

Reply to this Message

Rick Brandt - 04 Apr 2007 18:48 GMT

> Hi,
>
[quoted text clipped - 17 lines]
>
> 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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Jeff Stroope - 04 Apr 2007 19:46 GMT

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

Signature

Thanks,

Jeff

> > Hi,
> >
[quoted text clipped - 27 lines]
> objects. You will lose all your permissions settings doing that, but it
> might get you going again.

Reply to this Message

Joan Wild - 04 Apr 2007 18:52 GMT

> 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
[quoted text clipped - 13 lines]
> 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.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Jeff Stroope - 04 Apr 2007 19:08 GMT

Thanks for the quick response guys. I'll

Signature

Thanks,

Jeff

> > Hi,
> >
[quoted text clipped - 36 lines]
> you import, hit Ctrl-G, Debug menu, Compile and then Save. Follow that with
> a compact of the database.

Reply to this Message