|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Wizard IssuesI secured my database using the wizard and am supposed to have multiple
users. Everything worked great on my computer. When anyone else tried to open the file, it said they didn't have the correct permissions. I used the user names to match our Windows logins. What did I do wrong? "Annemarie" <Annema***@discussions.microsoft.com> wrote in message Users on other computers need to join your custom workgroup. Typically, news:C4EFA1FD-C5E4-4F08-A974-2C4E26BC28A7@microsoft.com... >I secured my database using the wizard and am supposed to have multiple > users. Everything worked great on my computer. When anyone else tried to > open > the file, it said they didn't have the correct permissions. I used the > user > names to match our Windows logins. What did I do wrong? you'd store your workgroup file on a network server in a common folder and use a desktop shortcut in the following format to join it on a session-by-session basis: "full path to MSACCESS.EXE" "full path to your app.mdb" /wrkgrp "full path to your workgroup file.mdw" including the quotation marks. You should also consider splitting the database and giving each user their own front end file. HTH - Keith. www.keithwilby.com Would this allow people not listed in the file to access the database as read
only? If not, how would I do that? Also, what do you mean by splitting the database and giving users a front end file? I don't quite understand. Thanks Show quoteHide quote "Keith Wilby" wrote: > "Annemarie" <Annema***@discussions.microsoft.com> wrote in message > news:C4EFA1FD-C5E4-4F08-A974-2C4E26BC28A7@microsoft.com... > >I secured my database using the wizard and am supposed to have multiple > > users. Everything worked great on my computer. When anyone else tried to > > open > > the file, it said they didn't have the correct permissions. I used the > > user > > names to match our Windows logins. What did I do wrong? > > Users on other computers need to join your custom workgroup. Typically, > you'd store your workgroup file on a network server in a common folder and > use a desktop shortcut in the following format to join it on a > session-by-session basis: > > "full path to MSACCESS.EXE" "full path to your app.mdb" /wrkgrp "full path > to your workgroup file.mdw" > > including the quotation marks. > > You should also consider splitting the database and giving each user their > own front end file. > > HTH - Keith. > www.keithwilby.com > > > "Annemarie" <Annema***@discussions.microsoft.com> wrote in message You'd need to create an account with read-only permissions (eg "guest").news:15CFBB17-7DA1-4EB3-AF27-B2BAFBB4DF0E@microsoft.com... > Would this allow people not listed in the file to access the database as > read > only? If not, how would I do that? > Also, what do you mean by splitting the Search the help for "split database". Sorry for the hurried reply, just > database and giving users a front end file? I don't quite understand. > Thanks going home now. Keith. 
Other interesting topics
Why are all access database I open asking for log on?
Security-Is there a better way? Help with an IF statement for the groups Need help with security Security permissions to convert the database Load Form Based on Current User's Group Need help securing an application with detail records PASSWORD PROBLEM in .MDW FILE Locking a database Network security |
|||||||||||||||||||||||
