Kath Pelletti
KP at sdsonline.net
Sun Feb 5 18:36:21 CST 2006
John - this happened to one of my clients recently. I doubt this will be your solution, but they had a database where they *could* run queries through the query window. (not a system I had written). Anyway, records were disappearing all the of the time - turned out it was as simple as a new staff member not knowing that after running a query you DON'T delete the recs returned in the dynaset. Ah, well - you get what you pay for , eh? :) Kath ----- Original Message ----- From: John Clark To: accessd at databaseadvisors.com Sent: Saturday, February 04, 2006 1:51 AM Subject: [AccessD] Missing records We got a call from a department that has a small Access 2K db. "Something" has happened, and they are missing about a quarter of their records. This was being investigated by a technician and I was just asked the following question: If a PC is "hard-booted" can an Access DB lose records w/out showing signs of corruption (i.e. the db still runs)?" I really don't know the answer to this question. I have had nearly no experience w/db corruption, since starting with Access 5 years ago. I used to use FoxPro...there are still some old FoxPro 2.6 (DOS) dbs hanging around actually...and corruption was a huge problem w/them. Anyone got any tips on this? Thanks! John W Clark -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com