PDA

Click to See Complete Forum and Search --> : MS Access Table getting deleted automatically

GeoNav
October 26th, 2009, 02:37 PM
Hi all,
in my MS Access 2003 Db, new tables that I create get deleted automatically within about 10-15 min. I am really in panic. Any suggestions, please!
Shuja Ali
October 26th, 2009, 02:45 PM
It is very difficult to find out how a table gets deleted when you have already created it without knowing the background and what kind of applications are accessing this particular Access MDB file.

Maybe you might want to check, if the file is being deleted and then replaced with some other version. Or Maybe some other application is removing the tables form the MDB file.

We cannot say much as we do not know the system that you are working on and as already mentioned we don't know what kind of applications are accessing this MDB file.
GeoNav
October 27th, 2009, 10:31 AM
The DB is being accessed by a .net 3.5 C# application only. The OS is Windows XP SP2. Db is in MS Access 2003. I am using OLEDB through Microsoft.Jet.OLEDB.4.0.
Shuja Ali
October 27th, 2009, 12:27 PM
Well as I have already mentioned, with this sort of information we cannot provide much help. You will have to go through the application and find out what is happening within the application code. Access will not delete the tables by itself.