Proliferating .ldb files

Topic

New Reply

I just looked at my Norton recycle bin and there are 87 copies of one Dbs .ldb file, from when I was in the Db for about 2 minutes doing virtually nothing. I opened and immediatley closed the Db and there were another 7 copies.
I am using Access 2000 on win2000, the Db is split and it is the Data Db whose .ldbs are proliferating in the recycle bin.
This seems really weird. Anyone have any ideas what is going on?

Reply | Quote

Replies

Why would the files be there at all? This isn’t something Access is doing. When you leave a database, it automatically destroys the ldb file, and until then you can’t delete it. What Norton product are you using? It sounds like it’s stashing copies of the lock file in case you crash.

Reply | Quote

Using Norton system works 2001. But all I have running is Norton Protected Recycle Bin. No other part of Sys Works is running.
This doesn’t happen with any other Db, just this one. Sure beats me!!

Reply | Quote

I don’t use that type of utility, so I can’t be much help on it. However, when you see one database behaving differently from others, you have to start tracking down the differences in order to avoid the same problem in the future. I’d start by creating a whole new database and importing everything from that one into it. See if the new database does the same thing. If so, then it may be something about the way it was built that causes it. In that case, start looking specifically at what makes this database different from the others: were they all created in the same version, do they all have the same references set, are any using an activex control, are they all using the same object model (DAO or ADO), etc.

Reply | Quote

Adding on to what Charlotte suggested, what is different about this database. Is it on a different drive? Is it in a different directory? What about the settings for the Norton utility? Does it allow you to specify drives, directories, and/or filenames to protect when deleted?

Reply | Quote

I didn

Reply | Quote

I think what you are looking at is different than the Recycle Bin. The unerase utility just goes out to find all instances of a deleted file in your directory (that is filenames that contain a ‘?’ as first character). These may or may not be recoverable. I wouldn’t worry about it.

Reply | Quote