User Permissions

24 Mar 2009 12:47 AM

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

24 Mar 2009 1:29 AM

John W. Vinson

On Mon, 23 Mar 2009 20:47:12 -0400, "Sam" <bu***@qqq.com> wrote:

>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

--

John W. Vinson [MVP]

25 Mar 2009 3:37 AM

Sam

Show quote Hide quote

"John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:rjdgs45083dl8m7iffclisgqvmihq03cdm@4ax.com...
> On Mon, 23 Mar 2009 20:47:12 -0400, "Sam" <bu***@qqq.com> wrote:
>
>>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

--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.

25 Mar 2009 4:25 AM

John W. Vinson

On Tue, 24 Mar 2009 23:37:30 -0400, "Sam" <bu***@qqq.com> wrote:

>--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.

--

John W. Vinson [MVP]