Problems with Access 2000 security...

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

I have an access 2000 project that is split into a front/back end.

I have made many changes to the front end on my development machine. Just
prior to making these changes, I copied the live front-end over to my dev
machine.

Today I copied the front end back over from my dev machine to the live
machine and had to delete and recreate the link tables.

Is this why all of the security to the tables has to be reconfigured? -
because I had to go thorugh all of the groups and re-assign the security
rights to the tables again!! - what a pain.

Is there a way to maintain access rights to tables when you are using link
tables which have to be deleted and re-added each time I copy my front end
from dev-> live??

Thanks,

Brad
 
Hi, Brad.
Today I copied the front end back over from my dev machine to the live
machine and had to delete and recreate the link tables.

Is this why all of the security to the tables has to be reconfigured? -
because I had to go thorugh all of the groups and re-assign the security
rights to the tables again!! - what a pain.
Click to expand...

You misunderstand. Once you delete an object, it's gone. Any security
permissions assigned to that object are gone, too. If you later create a
new object and give it the same name as an object that's been deleted in the
past, it's not the same object that you deleted. The new object won't
magically receive any security permissions that some other object once held.
Is there a way to maintain access rights to tables when you are using link
tables which have to be deleted and re-added each time I copy my front end
from dev-> live??
Click to expand...

There's no way to "hold" the security permissions of objects that have been
deleted. However, you could use Sandra Daigle's utility to script the
security permissions of all objects in the live version of the database
before you replace it with the dev version of the database. Then you could
delete the dev table links, and recreate the live table links, and run the
script you made to reapply security permissions on the new live database.
Please see the following Web page for her utilities:

http://www.Daiglenet.com/MSAccess.htm

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top