|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
access security permissions over a networkI 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 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" -- Show quoteHide quoteJoan 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 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 > > > There is a splitter wizard, but since it's secured, you'll want to split it
manually. See www.jmwild.com/splitsecure.htm -- Show quoteHide quoteJoan Wild Microsoft Access MVP "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 >> >> >> |
|||||||||||||||||||||||