Covert to 97 to 2003

[Ron]

Hi all,

The former IT guy in our company created DB in access97.
My boss want to convert it to 2003, but the creator put security and I was
not able to convert it or import the objects to a new DB.
I have never met this guy and he left the company long time ago without
leaving any information or passwords.

What can be done?

Thanks,
Ron

 

[Douglas J. Steele]

Did he put Access User-Level Security on it, or just a password? (Do you get
prompted to enter a User ID and Password when you use the application, or
just a password?)

If it's just a password, you might be in luck. Check what MichKa has at
http://www.trigeminal.com/codes.asp?ItemID=5#5

It it's User-Level Security, you might have to pay to have the security
broken on it.

 

['69 Camaro]

Hi, Ron.

What can be done?

If it's an Access 97 database password, then that's easily read by a VBA
procedure you can find on the Internet. If it's User-Level Security, it may
be more difficult, but it's not guaranteed to be so. Since most people fail
to implement User-Level Security correctly the first 20 or so times they
attempt it, chances are good that the database isn't really secured. Have
you tried opening the database file while joined to the default workgroup?
If that doesn't work and you have the workgroup information file that was
used to secure the database, check all of the members of the Admins group to
determine whether any of them don't have a password or have an
easily-guessed password, and use that member to open the database and import
all of the objects into a new, unsecured database, then convert that
unsecured database to Access 2003. If there aren't any members of the
Admins group that left the door unlocked, then see if you can give the Users
group Administrative permissions on all the database objects, and import all
the objects into a new, unsecured database, then convert that to Access
2003.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.