Database copying itself

G

Guest

I'm having some weird stuff going on with a database of
mine and I was wondering if anybody had any ideas. We
run this database over a network, and recently I've
noticed that the database is copying itself and naming
those copies db1, db2, etc. Is the copying evidence of
dropped network connections? I haven't picked up on any
performance issues with the database and no one has said
anything about error messages, but I think we may have
some issues with the nic card on one of the computers, so
I'm thinking this could be it. The nic card is being
replaced tomorrow, so I guess my question might be
answered by then, but I thought I'd ask it anyway.

Thanks
Tara
 
J

John Vinson

I'm having some weird stuff going on with a database of
mine and I was wondering if anybody had any ideas. We
run this database over a network, and recently I've
noticed that the database is copying itself and naming
those copies db1, db2, etc. Is the copying evidence of
dropped network connections? I haven't picked up on any
performance issues with the database and no one has said
anything about error messages, but I think we may have
some issues with the nic card on one of the computers, so
I'm thinking this could be it. The nic card is being
replaced tomorrow, so I guess my question might be
answered by then, but I thought I'd ask it anyway.
Click to expand...

One possibility is that you have Compact on Close set, but the user
doesn't have Delete privileges on the folder containing the database.
The way Compact works is that Access creates a new database named db1
(or db2 if there already is a db1, etc.), copies everything into it,
deletes the old database and renames the new one. If the user doesn't
have the right network privileges this process won't complete.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top