Using access db on networked drive

[SilverSN95]

Hi, for a project I am working on, I plan on placing an Access database on a network drive to run as the back end for two processes.
-An excel file that will query the data-base to auto fill form fields from the database for the user.
-In simular file, VBA code using an DAO connection to the same database can submit a new entry to the database.

My question is, how will these types of connections deal with multiple users. If two people tried to connect and submit info at the same time, would one of the entries get dropped, and would the user be informed of a problem? What if the one excel file is running the query while someone else attempts to submit info?
I know this isn't entirely a VBA-based question, but I'm sure people here have dealt with this kind of thing before, and I could really use any advice.
Thanks again for your help :).

[Oorang]

In that scenario it's pretty unlikely to have an update conflict. But you could have a scenario where both people pull down info. Person1 commits a change to Fields 1, 2, & 3. Then Person2 commits a change to fields 1 & 3. But because field 2 was populated before person 1's changes when person 2's commit occurs it will overwrite person 1's change.

You can avoid that scenario by only comitting changes to the pulled data. So if I change fields 1 & 3 you only update fields 1 and 3. In this scenario you will then be simplified down to "last change wins".

An example:
I populate a form with Name, Address, and Phone. I change Address and Phone, but not Name. The program checks to see if the new values are different from the values as they were when originally queried. If they are a write will happen. Do not check against values as they are now. This can lead to misidentifying and overwriting changes that have occured since the data was pulled.