Using Access 2000 and Access 2003

[Sarah0824]

I set up security on a db for a client. The original db was created in
Access 2000. When we created the security, we used Access 2003. However,
once we set all the users up, we noticed that the permissions were not
working. Even though we have specified that one of the users is to only
insert data in 2 forms, she can open any object in the db. Is this because
the db was created in Access 2000? If not, what is causing this? Would a
fix be to convert the db to the 2003 file format? If I remember right,
however, this would lock out any users still on Access 2000 (there is still
one who needs to use the db). Any help would be appreciated!!

 

[Joan Wild]

Sounds like you missed a step in securing it. There shouldn't be any
problems securing a 2000 format mdb in 2003.

Double check the permissions on the Users Group, and also verify that the
Admin User doesn't own anything.

 

[Sarah0824]

Thanks for your quick response!!

The users group has no permissions, however, the Admin owns everything. I
cannot change ownership - the box is grayed out. I guess I need more help
than I thought. I'm a newbie at the security thing.

 

[Joan Wild]

If the Admin user owns everything, then you missed a crucial step in
securing the database.

You need to login as a different user (the one you want to have own
everything), create a new database and import all the objects.

Importing the objects will cause them to lose their permissions, so you'll
have to re-apply them.

There is a utility at www.daiglenet.com called dbUtilities you can use to
help with this. Run it in your mdb as is. Once you create the new mdb, you
can run it again to apply the permissions.

 

[Sarah0824]

Thanks. I know exactly what I did and why it happened that way. I
appreciate your help!