Access Userlevel Removal

[aussieolie]

Hi,
Could anyone tell me how to reset permissions on a database (I dont want the logon prompt to pop up). When I delete the MDW file I get told I dont have permission to access the db.

All i want is for one user, with normal admin access (no pw).

Thanks,

Olie

 

[Autoeng]

Try creating a blank db and exporting everything from the secured one into the unsecured one. If you open an unsecured db does it ask you for a password on your computer. If it does you will have to join an "unsecured" security workgroup as well.

Autoeng

 

[aussieolie]

THanks. I think this works.

Olie