2003 user log-in

[Blake]

Hello,

I have finished my data for my job. I have granted user log-ons and
permissions. I also have custom menu bars based on who logs in.

I went to go up load it to the server and when we went to go open it it was
fine on my computer but on any other users computer it opened as the standard
Admin. So their is no custom bars and everyone can access everything.

Thanks
Blake

 

[Chris O'C via AccessMonster.com]

If users can open your db without your secure workgroup file, the db wasn't
secured properly. It's easy to miss a step or 2.

User level security is an advanced topic and very complicated for new users.
Read and study the security faq, practice on a copy of the db, and then
secure the db when you're ready.

http://support.microsoft.com/?id=207793

Chris

 

[Chris O'C via AccessMonster.com]

Did you split the db before you put it on the server? Multiple users sharing
the same db file causes db file corruptions. It's hard to upgrade an unsplit
db too.

Split the db file into a front end and back end. Put the back end db (with
the tables and relationships) on the server. Put a copy of the front end
(with table links and everything else) on each user's pc.

Chris

 

[Chris O'C via AccessMonster.com]

Don't use the db splitter wizard to split your secure db. It automatically
creates a new db file for the back end - and it's unsecured.

Split the db manually.

Chris

 

[Blake]

Chris,

You information is perfect. Thanks for the assistance.

I do have one last question. When I go to open the db with "Exlusive"
Rights I get an error that tells me "You do not have permission to open
\path for eclusive use."

Thanks again,
Blake

 

[Chris O'C via AccessMonster.com]

Log in as a member of the admins group. Give the groups who need to open the
db exclusively the permission by using the menu: Tools > security > user and
group permissions.

On the permissions tab, click on groups in the List options. Click on the
group name in the User/group name list box. Choose database for the Object
type combo box. Check the box for Open exclusive.

You could also give individual users open exclusive permissions, but then
you'd have to individually revoke and grant them. Better to give a group
permissions and assign the member to that group.

Chris