Data loss in Access-97 from VB 6.0
I have encountered Random data loss in our access database.
Sometimes the users call in saying that the records entered by them
are lost. The users, use our VB front end to enter the data (Users do
not enter data directly into the database)
Most of the times I have noticed that the problem occurs when users
add new records.
All our tables have a unique alpha-numeric primary key.
Our Setup
VB 6.0 SP6 (Enterprise) application on a Citrix Metaframe server
MDAC 2.8
Jet SP2
Access database is located in app path which is a shared network
drive.
ADO
Any limitations on Access-97 on a Citrix Metaframe server ? (My
problems started after we migrated to a 2000 Metaframe server from a
NT Metaframe server)
Any hints or pointers that can help me trouble-shoot this random data
loss is greatly appreciated.
Thanks & Regards,
Sid
