> I didn't design the original 97 db, but as far as I understand there
> is no security on it. We don't have to enter a user name or password
> when opening the db in 97, and it works on any workstation that has
> Access 97.
Well it sounds as though it is secure. You say you don't have to enter a
username/password, but are you starting it via a desktop shortcut? If so,
have a look at the shortcut to see if it specifies a workgroup file
(/wrkgrp), and includes the username and password switches.
> Any other suggestions how to go about this? Can I for instance
> remove the security that may be on the 97 db since I have full access
> working with the db in 97?
You can try. Open Access 97 and create a new mdb, and try importing all
objects from your mdb.

Signature
Joan Wild
Microsoft Access MVP
Liz Hansen - 07 Feb 2005 19:10 GMT
I will try that. Thanks!
Liz
> > I didn't design the original 97 db, but as far as I understand there
> > is no security on it. We don't have to enter a user name or password
[quoted text clipped - 12 lines]
> You can try. Open Access 97 and create a new mdb, and try importing all
> objects from your mdb.