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/ex...ributors2.html for contact
info.
"Ron" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>
Similar Threads
