Multi User

  • Thread starter Thread starter L. Ann
  • Start date Start date
L

L. Ann

We have an Access database on the company server. What do I need to do to
allow more than one user update information in the database?
 
The simple answer is just to split the database and then allow each user to
access the front-end.
It's considered best to have each user have their own copy of the front end,
but I've had a heavy-duty application running fine for years where all users
shared the same front-end.
There are many other possible issues depending on what your application does.

-Dorian
 
I should have defined my problem a little more. Employee 1 enters
information in the first 5 fields of a record of the table in table view.
Employee 2 enters information in the last 3 fields in table view for that
record. Therefore, Employee 2 needs to be able to see the information that
Employee 1 has entered. Neither employee uses a form to enter information.
Thanks!
 
In general, it is much better to use forms to enter data instead of entering
date directly into a table. If you want the look and feel of a table, then
design a continuous form, or use an unbound main form with a subform that is
in datasheet view.

As long as the last three fields that employee #2 needs to enter are not
required fields, then I see no problem. Obviously, employee #1 will not be
able to commit (save) the record if one or more of the last three fields is
required (unless you have a default value that gets added). So, I really
don't see why you needed to add the additional clarification. Just follow the
steps I outlined in my Multiuser Applications paper.

Good Luck,

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Back
Top