If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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.
|
#2
|
|||
|
|||
Database duplication
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 |
#3
|
|||
|
|||
Database duplication
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 |
Thread Tools | |
Display Modes | |
|
|