db.mdb

[jstp]

Why are files being created such db1.mdd, db2.mdb, etc.? Are they auto
created backups? Do I need to save them? BTW - my db lives on a server.
Thanks in adv.

 

[Arvin Meyer]

Why are files being created such db1.mdd, db2.mdb, etc.? Are they auto
created backups? Do I need to save them? BTW - my db lives on a server.
Thanks in adv.

Typically those are files made from incomplete database compaction or from
people trying to create a new empty database. The usual way to tell the
difference is that the new ones will always be under 128K.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Kai Apel \(Berlin\)]

when you are creating a new database (local) you can name your mdb-file by
ourself or i you only click <RETURN> then you named the mdb-file automaticly
db(Number).mdb. You needn´t that files, I guess there are only there because
you where pressing the return-button at this dialog-box, but you can
check-out. start the mdb´s and see, what happen there.

Kai Apel (Berlin-Germany)

 

[jstp]

Thanks for the quick response. These files are usually quite large 7000+ kb.
Any ideas?

 

[Arvin Meyer]

More than likely failed or incomplete compactions. Back up your database
then ask if anyone has any knowledge of them. Open a few up and see if they
have the same tables as your database. If so, they may probably be safely
deleted.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[jstp]

Thanks very much!

More than likely failed or incomplete compactions. Back up your database
then ask if anyone has any knowledge of them. Open a few up and see if they
have the same tables as your database. If so, they may probably be safely
deleted.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[John Vinson]

Thanks for the quick response. These files are usually quite large 7000+ kb.
Any ideas?

Just to add to Arvin's comments - one way this can happen is if you
have Compact on Close set, but the user running the database does not
have full create/delete/update privileges on the server folder
containing the database. Check your users' privileges!

John W. Vinson[MVP]