Database Security - Permissions

[Buckmac]

Security panic - Help!!!

Hi, having created my database and done weeks of work, as part of getting ready for live use, I wanted to secure the database.

Somewhat naively, I ran the wizard. I now find that none of the users has any kind of capability at all other than to just open forms to view stuff. No one can enter any data, I can't alter any forms or export them, change their permissions or any damn thing. I'd hate to have to do all that work again.

Any suggestions please???? I'm panicking here.

Chris B.

Forgot to mention - it's Access 2000 under W2K

 

[FloBob]

Did you save the usernames and passwords?... it shoudl of created an admin to be able to get into the forms etc. Always make a backup before you perform that wizard though it does some things funny.. I know thats not quite what you wanted to hear though. If you dont have a backup.. maybe you have one on a server that is backed up regularly?... im reaching but I hope this helps