By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,249 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Create Workgroup

P: 83
I want to create a workgroup for my office. First, I went to tools and created a workgroup and put it in the shared drive. I then created users. Then when admin is clicked I create a new password and verified it. If I exit and log in under admin with the password, it works. If I go to log in with a user and type in the admin password, it doesn't work...it says invalid password or username.

Secondly, I want different users to be able to save at the same time. When I created a workgroup without a password, if one user was logged on, another user wouldn't be able to edit?

Does anyone have any solutions?
May 9 '07 #1
Share this Question
Share on Google+
4 Replies


ADezii
Expert 5K+
P: 8,619
I want to create a workgroup for my office. First, I went to tools and created a workgroup and put it in the shared drive. I then created users. Then when admin is clicked I create a new password and verified it. If I exit and log in under admin with the password, it works. If I go to log in with a user and type in the admin password, it doesn't work...it says invalid password or username.

Secondly, I want different users to be able to save at the same time. When I created a workgroup without a password, if one user was logged on, another user wouldn't be able to edit?

Does anyone have any solutions?
  1. The specific Password you created for the Admin User is for this User only. You cannot log on with another User Name, apply the Admin Password, and expect it to work.
  2. Whether or not you have a Security System that requires Passwords, should have no effect on the capability of Users to edit data.
  3. You may want to rethink your overall Security Strategy. Instead of creating Users and assigning permissions to them, create Groups, assign specific permissions to these Groups, then assign Users to these Groups.
May 9 '07 #2

P: 83
I sort of understand what you are getting at. But, only one user can edit the master log at a time? why would that be. Even if i delete the workgroup and just put it on the share, after one user is in it, it says "can't edit"
May 9 '07 #3

Expert 100+
P: 344
I sort of understand what you are getting at. But, only one user can edit the master log at a time? why would that be. Even if i delete the workgroup and just put it on the share, after one user is in it, it says "can't edit"
Editing the records and user security are two seperate issues. Having your users log-on via a workgroup means you can apply security to the objects in the database and keep track of who is doing what.

However, if you want 2 or more users to edit the same table at the same time, then you have record locking issues. Using unbound forms is one way of solving these issues but they may be other ways in the later versions of access.
May 9 '07 #4

ADezii
Expert 5K+
P: 8,619
I sort of understand what you are getting at. But, only one user can edit the master log at a time? why would that be. Even if i delete the workgroup and just put it on the share, after one user is in it, it says "can't edit"
Check ==> Tools ==> Options ==> Advanced ==> Default Record Locking
May 9 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.