Multi User

[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?

 

[mscertified]

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

 

[Tom Wickerath]

I have just the article for you!

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm


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

 

[L. Ann]

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!

 

[Tom Wickerath]

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
__________________________________________