Passwords or Creating Workgroups

[Needhlp]

I have developed an MSAccess Database on my Workstation with an authorized MSAccess License, and I need now to share this Database with other people from your company that do have MSAccess license as well.

I also need to secure my Database with access, read, modify and delete options because only one user knows how to run simple queries and create basic tables but the others only know how to enter data and analyse the info with Excel.

From what I understand, I am the admin and they are the users.

Question 1: Is it possible to unset the "Exclusive mode" to allow the users to enter data at the same time the Admin does?

Question 2: Is there another way to limit the access and define permissions other than with Workgroup - Workgroup Administrator does not seem to be user friendly. Would it be better to create a switchboard?

Question 3: Is there a site where I can get detailed instructions (courses) on Workgroup settings?

Thanks a zillion.

 

[David Eagar]

Before spending any time learning workgroups, are you planning to upgrade to Access 2007? If yes, workgroups wont exist

 

[boblarson]

Also, if you are going to be using this with multiple users you NEED to split the database and give each user a copy of the frontend on their computer.

See here for more on that:
http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

And, if you want a tool to help with auto updating of frontends then you can use this tool of mine to enable auto updating:

http://www.btabdevelopment.com/main/AccessTools/tabid/78/Default.aspx

 

[Needhlp]

Our firm (international) is sticked to 2003! Unfortunately I have to deal with the 2003 version at the office!