HELP!!! locked myself out of my own db!!

[icic]

Hi

I know this sounds stupid but on my database with user-level security, i have somehow managed to remove administer rights from all users , and do not know how to change it back, if it is even possible.

I think what might have happened is it was stored on my USB drive and i switched computers and opened the db, would that have affected it?

Is there an easy way out of this or am i screwed?

thanks, ian

 

[ColinEssex]

Try pressing the [shift] key, keep it pressed and press [return] to enter the Db.

Col

 

[icic]

ive tried this, but i still cant give any of the users administrator rights (not even admin!)

 

[ColinEssex]

You may need to open a blank database and transfer the tables etc and do it again, a bit more carefully

Unless someone else knows a way

Col

 

[Exodus]

Sound like you need the mdw file for that db