Using Access 2003 as a front end MSSQL 2005, a few tables have random data disappear. What is troubling is sequential data as auto-increment. The first field is an auto-increment and from the Access side it auto-increments and seems to post correctly, but sometime time in the future when the user goes back to the data table the data is not there randomly and the auto-increment acts like it never incremented.
I've checked this from the MSSQL side and sure enough the data acts like it never posted. The auto-increment goes onto the next available number.
I tested this with self created data. I entered some data, it auto-incremented and then I deleted these rows. The very next auto-increment was where it should be, skipping the last few numbers I just deleted.
Start Free Trial
