User Permissions

[Sam]

We have a proprietary application built in access ’97 when we copy the
application to other PCs then run the install routines some users lose their
advanced permissions. Is there one file that contains user information? If
so, where can we find that file? If it isn’t contained in one file where
is this data stored?
How do we copy exact user permissiuons from the original access db?



Thanks

 

[John W. Vinson]

We have a proprietary application built in access ’97 when we copy the
application to other PCs then run the install routines some users lose their
advanced permissions. Is there one file that contains user information? If
so, where can we find that file? If it isn’t contained in one file where
is this data stored?
How do we copy exact user permissiuons from the original access db?



Thanks

The *object permissions* are stored in the .mdb file... but the users and
groups are stored in the associated .MDW file. It's pretty easy to goof up
security; it SHOULD have been done using a separate custom .mdw file for each
application, but it may well have been done using
C:\Windows\System32\SYSTEM.MDW which is the default security file for all
databases on that computer.

Open the database in question, and select Tools... Security... Workgroup
Administrator to identify the workgroup file in use.

You may want to download and *carefully study* the Microsoft Access 2000
Security FAQ:

http://support.microsoft.com/kb/207793/en-us

 

[Sam]

The *object permissions* are stored in the .mdb file... but the users and
groups are stored in the associated .MDW file. It's pretty easy to goof up
security; it SHOULD have been done using a separate custom .mdw file for
each
application, but it may well have been done using
C:\Windows\System32\SYSTEM.MDW which is the default security file for all
databases on that computer.

Open the database in question, and select Tools... Security... Workgroup
Administrator to identify the workgroup file in use.

You may want to download and *carefully study* the Microsoft Access 2000
Security FAQ:

http://support.microsoft.com/kb/207793/en-us

--When I burned the application to CDs I had to burn the 4325MB DB file
separate from the application
then when it was installed on the new server the db file was moved to
another location i wonder if that somehow
screwed things up.

 

[John W. Vinson]

--When I burned the application to CDs I had to burn the 4325MB DB file
separate from the application
then when it was installed on the new server the db file was moved to
another location i wonder if that somehow

Did you copy the .mdw file as well? That would be required for a secured
database. Also if you copy a file from CD to hard disk it will come out
read-only; you need to use Windows Explorer to reset it to read/write (both
the frontend and backend). You may also need to relink the front to the
backend.