Are there issues with tables using an autonumber as a primary key in a back-end ms access db?
Posted
by
owlie
on Stack Overflow
See other posts from Stack Overflow
or by owlie
Published on 2011-01-05T03:46:35Z
Indexed on
2011/01/05
3:54 UTC
Read the original article
Hit count: 223
I inherited an MS Access database at my office that is heavily used by several people over the network. This causes many issues with data collisions and locks. I want to split the db so that each user has thier own front-end app and maintain the core data on the server.
Several of the tables use an autonumber:sequence:long as thier primary key - in researching how to perform the split I've come across several posts that hint this can cause issues when distributing a database but I haven't been able to find anything solid. The issue seems to be that a user can begin a new record and receive the next autonumber but a second user can create a new record within a short interval and receive the same autonumber resulting in an error?
Does Jet handle this correctly or are there autonumber issues with a FE/BE database? If it's an unlikely-but-possile occurance I'm sure it will still be much better than what my users are currently experiencing but I'd like to know if there are ways I can minimize such issues.
Thanks for your help!
© Stack Overflow or respective owner