opening up older database

[Eric]

I have an older database that was tied in to user ID from network logins on
our system. It has a User ID table that verifies the computer login ID of
the User. This was setup before my time as a backup security system to avoid
errant logins. The database hasn't been used in a few years and since then
we have changed network systems and login ID's are now numbers and not names.
So now we need to get into the old database but when opening it there are
error messages that say that the user (number ID ) is not authorized.
Is there any way to over-ride the logins to be able to open the database and
then change the User ID table to allow the appropriate people access?
Thanks for your help.

 

[Douglas J. Steele]

Depending on how the application was built, you could try holding down the
shift key while you're opening the application (i.e.: the database, not
Access itself). Keep holding it down until the database has opened. That
should bypass any code that runs at startup unless special action was taken
to disable that capability.

 

[Eric]

I've tried holding the shift key on starting the database, but it still has
the same error message. Any other ideas?
Eric

 

[Douglas J. Steele]

Try creating a new database and importing everything from the old database
into the new one.

If there's a macro named AutoExec, rename it before reopening the new
database.

 

[Eric]

Doug,

That worked just fine. Seems that there are a some items to debug with it
but for now that gives us the chance to get in and look at the data.
Someone in the company is interested in going back to using the old database
instead of using separate excel sheets. So that will mean some possible
debugging for me in the future.

Thanks for the help,
Eric