Who gets the priority to access when 2 users try to connect to?
-
if 2 users connect to access and run query that check the last number increase this number and insert record to database. Who gets the priority ? why i see 2 duplicate records with the same number ? thanks in advance
It sounds like you need a transaction; that's what they're for. I also don't recommend Access. X|
-
if 2 users connect to access and run query that check the last number increase this number and insert record to database. Who gets the priority ? why i see 2 duplicate records with the same number ? thanks in advance
What you need in this case is an auto-incremented number, such as a primary key, rather than relying on a number field which must be manually incremented. You could also increment the number when inserting the record, not before. I also agree with PIEBALDconsult, don't use Access. SQL Express is FREE and more robust than Access in multi-user scenarios. It also easier to upgrade to a full SQL Server implementation when necessary.
I know the language. I've read a book. - _Madmatt
-
What you need in this case is an auto-incremented number, such as a primary key, rather than relying on a number field which must be manually incremented. You could also increment the number when inserting the record, not before. I also agree with PIEBALDconsult, don't use Access. SQL Express is FREE and more robust than Access in multi-user scenarios. It also easier to upgrade to a full SQL Server implementation when necessary.
I know the language. I've read a book. - _Madmatt
Mark Nischalke wrote:
auto-incremented number
X|