Home All Groups Group Topic Archive Search About

access security permissions over a network

Author
16 Mar 2007 1:03 PM
A D
I have set user and group permissions on one database on one networked
machine on the domain but would like these to be applied over the network on
all machines is this possible? and how, does anyone know?
Server is on server 2003 computers on the network are Windows 2000 and XP
Pro and all have office 2003 pro. total database users 60

Author
16 Mar 2007 2:09 PM
Joan Wild
You need to put the secure mdw you used to secure your database on the
server.  You also should split your database, and put the backend on the
server as well.  Be sure to split it manually, since it's secure.  You'd
give each user a copy of the frontend on their workstation.

Then provide a desktop shortcut to your users with a target of...
"path to msaccess.exe" "path to frontend" /wrkgrp "path to secure mdw"

--
Joan Wild
Microsoft Access MVP
Show quoteHide quote
"A D" <A D@discussions.microsoft.com> wrote in message
news:D68D5288-5263-418F-BA41-076506107B4F@microsoft.com...
>I have set user and group permissions on one database on one networked
> machine on the domain but would like these to be applied over the network
> on
> all machines is this possible? and how, does anyone know?
> Server is on server 2003 computers on the network are Windows 2000 and XP
> Pro and all have office 2003 pro. total database users 60
Author
16 Mar 2007 3:06 PM
A D
Thanks for that Joan
I have copied the secure mdw and the database on the server but I dont know
how to split the data base into 2 parts (front and back) can you give me any
direction?

Show quoteHide quote
"Joan Wild" wrote:

> You need to put the secure mdw you used to secure your database on the
> server.  You also should split your database, and put the backend on the
> server as well.  Be sure to split it manually, since it's secure.  You'd
> give each user a copy of the frontend on their workstation.
>
> Then provide a desktop shortcut to your users with a target of...
> "path to msaccess.exe" "path to frontend" /wrkgrp "path to secure mdw"
>
> --
> Joan Wild
> Microsoft Access MVP
> "A D" <A D@discussions.microsoft.com> wrote in message
> news:D68D5288-5263-418F-BA41-076506107B4F@microsoft.com...
> >I have set user and group permissions on one database on one networked
> > machine on the domain but would like these to be applied over the network
> > on
> > all machines is this possible? and how, does anyone know?
> > Server is on server 2003 computers on the network are Windows 2000 and XP
> > Pro and all have office 2003 pro. total database users 60
>
>
>
Author
16 Mar 2007 3:38 PM
Joan Wild
There is a splitter wizard, but since it's secured, you'll want to split it
manually.

See www.jmwild.com/splitsecure.htm


--
Joan Wild
Microsoft Access MVP
Show quoteHide quote
"A D" <A*@discussions.microsoft.com> wrote in message
news:AAA0B1B6-9803-486A-A430-3C01ECEB63EA@microsoft.com...
> Thanks for that Joan
> I have copied the secure mdw and the database on the server but I dont
> know
> how to split the data base into 2 parts (front and back) can you give me
> any
> direction?
>
> "Joan Wild" wrote:
>
>> You need to put the secure mdw you used to secure your database on the
>> server.  You also should split your database, and put the backend on the
>> server as well.  Be sure to split it manually, since it's secure.  You'd
>> give each user a copy of the frontend on their workstation.
>>
>> Then provide a desktop shortcut to your users with a target of...
>> "path to msaccess.exe" "path to frontend" /wrkgrp "path to secure mdw"
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>> "A D" <A D@discussions.microsoft.com> wrote in message
>> news:D68D5288-5263-418F-BA41-076506107B4F@microsoft.com...
>> >I have set user and group permissions on one database on one networked
>> > machine on the domain but would like these to be applied over the
>> > network
>> > on
>> > all machines is this possible? and how, does anyone know?
>> > Server is on server 2003 computers on the network are Windows 2000 and
>> > XP
>> > Pro and all have office 2003 pro. total database users 60
>>
>>
>>