Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rrb
SQLTeam Poet Laureate
1479 Posts |
 Posted - 2005-08-24 : 23:35:16
|
| HiI have a system where password protection (via workgroup security file) needs to be removed. I have the admin password (nothing naughty going on here!)Since I never use this form of security, I'm unfamiliar with what needs to happen to get back 0 security (with no workgroup file). I can obviously just log in and give everyone priveleges to everything - but I suspect I'll still need the workgroup file - I guess I'm really asking: how do I remove the need for the file?Any advice gratefully received - I'm an access security novice.--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-08-25 : 09:18:03
|
| Usually, the eaisest thing to do is just create a brand new, empty database will no protection, and then import all of the objects from the protected database into it. I had similiar problems in the past when we upgraded some very old Access 97 databases to Access 2000, and even though I had all the admin privledges I still couldn't perform the upgrade.This way, you get a nice clean new MDB. Of course, if it is a complicated MDB file with lots of VBA you will have to re-establish references and things like that, but overall the "import everything" works pretty well. |
 |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-08-28 : 19:44:45
|
| Thanks Dr Crossso the workgroup security file is linked to the particular mdb and not the installation of access??Ta--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
|
|
|
|
|
|
Removing password protection