Setting Up Users Rockwater 6/26/2006 11:41:01 PM I was looking for some help with setting up users for my DB. Because of where I work the DB is on a shared drive so all user with access to that drive can access the DB. I would like to assign user but the last time I tried it only worked on my computer and not the others. Any help or guidance would be welcomed!

Re: Setting Up Users "Arvin Meyer [MVP]" <a[ at ]m.com> 6/27/2006 1:01:24 AM First you need to split your database into an application and the data tables. There's a wizard to help you.: Tools ... Database Utilities ... Database Splitter Link the application to the tables which will reside on a server, and place a copy on each workstation. To avoid conflicts you need a server. A machine running server hardware and software is preferrable, but a spare workstation will do if you have nothing else. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads http://www.datastrat.com http://www.mvps.org/access "Rockwater" <Rockwater[ at ]discussions.microsoft.com> wrote in message news:F18D43F3-EAAF-4DF6-8C4E-4BCF37D57AF0[ at ]microsoft.com... [Quoted Text] >I was looking for some help with setting up users for my DB. Because of > where I work the DB is on a shared drive so all user with access to that > drive can access the DB. I would like to assign user but the last time I > tried it only worked on my computer and not the others. Any help or > guidance > would be welcomed!

Re: Setting Up Users "Yiming" <yiming_915[ at ]163.com> 6/28/2009 2:49:54 AM "Arvin Meyer [MVP]" <a[ at ]m.com> дÈëÏûÏ¢ÐÂÎÅ :#$oq5UYmGHA.5076[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > First you need to split your database into an application and the data > tables. There's a wizard to help you.: > > Tools ... Database Utilities ... Database Splitter > > Link the application to the tables which will reside on a server, and place > a copy on each workstation. To avoid conflicts you need a server. A machine > running server hardware and software is preferrable, but a spare workstation > will do if you have nothing else. > -- > Arvin Meyer, MCP, MVP > Microsoft Access > Free Access downloads > http://www.datastrat.com > http://www.mvps.org/access > > "Rockwater" <Rockwater[ at ]discussions.microsoft.com> wrote in message > news:F18D43F3-EAAF-4DF6-8C4E-4BCF37D57AF0[ at ]microsoft.com... > >I was looking for some help with setting up users for my DB. Because of > > where I work the DB is on a shared drive so all user with access to that > > drive can access the DB. I would like to assign user but the last time I > > tried it only worked on my computer and not the others. Any help or > > guidance > > would be welcomed! > >