Database duplication

I'm seeing a duplication of my database, every time I make a revision. My original stays in tact, but the database name starts with the default db1 and keeps going, I'm now at db80.mdb. I cannot access the duplicate database I receive a g warning about not being able to find the object MsysDb.

On Mon, 7 Jun 2004 06:46:06 -0700, "pw28216"
wrote:

I'm seeing a duplication of my database, every time I make a revision. My original stays in tact, but the database name starts with the default db1 and keeps going, I'm now at db80.mdb. I cannot access the duplicate database I receive a g warning about not being able to find the object MsysDb.

What kind of "revision"? You're doing something out of the ordinary! A
..mdb file is just a container for multiple tables, forms, and so on;
ordiarily one would edit and save a form within the .mdb file, not
creating a new database.

Doublecheck that you have full read, write, create and delete
privileges on the folder containing your database. If you have Compact
on Close enabled (or routinely compact your database) Access will
indeed create a new dbXX database and attempt to delete the old
database and rename the new one.

I would suggest deleting db1 through db80 (back them up to CD or
another disk first to be safe); Compact the database and see if it
creates a new db1, and also check the size of both databases.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

John,

Thank you. It was the compact on close option. I knew something had been turned on just for this database. I didn't have this problems for any of my others. thanks again.

pw28216