View Single Post
Old February 25th, 2005, 07:15 AM
rjweers rjweers is offline
Friend of Wrox
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post

It sounds to me like you have left the Admin user as the owner of the MDB/E file and/or allowed the Admin user access to objects in the MDB/E file.

Access doesn't really know the difference between Admin in one MDW file from Admin in another MDW file. Hence, when you get the default MDW file by clicking on the MDB/E, you pass security checks. However, it does use a user's "Personal ID" in the MDW file to allow specific users access to objects in the MDB/E.

Try adding a new Admin user and making them the owner. Then remove the "Admin" user's permissions from everything.

Please remember to backup your MDB before you start switching owners and removing Admin user's permissions. If you forget the Password to the user you designate as the new Admin, you're pretty much screwed.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group