Wizard Issues

[Annemarie]

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?

 

[Keith Wilby]

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]

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

 

[Keith Wilby]

Would this allow people not listed in the file to access the database as
read
only? If not, how would I do that?

You'd need to create an account with read-only permissions (eg "guest").

Also, what do you mean by splitting the
database and giving users a front end file? I don't quite understand.
Thanks

Search the help for "split database". Sorry for the hurried reply, just
going home now.

Keith.