GOOD ONE! Disapearing records in Access
Posted on 2001-06-07
This is not going to sound possible but I've been doing shi* like this for years and do know what I'm doing. I'm stumped. I've never been able to replicate the problem it's happended about 4 times in 9 months in full blown production. Here goes.
There's a program that adds records to a Access97 table with dao3.5 addnew method (no trasactions).All errors are displayed and logged. Another program updates thoses records shortly after. Those updated records are later inserted to another MDB on another machine and marked. The issue is every once in a while the records just aren't there. There are no errors and all the programs run as normal but I look in the table and there is nothing there. The records generated from the first app use a sequance number kept in a table as aviliable sequance numbers. As they are used they are deleted. The first generating program is recognizing them as being deleted as it uses a Select min(num) SQL to get the lowest one and the number keeps incrementing. But if I go look at the table they are still freaking there! It will do this until someone notices. I reboot the machine and start over and the sequance numbers start over like nothing was ever deleted and every thing works. There is a lot more detail to the setup but most of it seems failrly irelevant.
It's almost like the changes are being kept in a transaction log and never being commited to the datafile and are lost once the programs close but from what I know
Access doesn't do that really. I don't get it. And I can't spell, sorry.
thanks in advance