|
Subject:
|
Simultaneous Entries (locking data)
|
|
Posted By:
|
needelp
|
Post Date:
|
9/15/2006 12:54:33 AM
|
Hey everyone,
is it possible to have one person one computer entering data, and have another person on another computer enter data in the same table at the same time
i have in place an automattic order number
e.g:
User1 opens order form
Enters data in record with auto order number 1234
User2 opens order form
next record opens with auto order number 1235
and is able to enter data at the same time as User1
any help would be much appreciated
cheers
Shane
|
|
Reply By:
|
echovue
|
Reply Date:
|
9/15/2006 1:04:13 AM
|
I am sure there are additional factors to consider, but if you split your database, then Access should take care of this for you.
Basically splitting the database, breaks it into 2 parts. 1 has your data and is the Back-End. The other has your tables, and what you end up having is a little Client-Server type application.
Hope that helps.
Mike
P.S. The more users that you have, the greater the potential for corruption. When you get up around 10 (I believe) it is time to migrate to SQL Server or something similar.
Mike
EchoVue.com
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
9/15/2006 11:09:37 AM
|
Another solution would be to store the records locally, like on MSDE, and then push completed records to an Access file as the transactions were committed.
Anywho, conventional wisdon is what echovue says. Split the database to avoid record locking issues for the most part.
SQL will still give you record locking issues, but it has finer control.
mmcdonal
|
