New Files being created

[bluedigital]

I have created an Access 2007 database on a network drive. I notice that as the database is being used, other files are being created sequencially such as, "database1", "database2", "database3", etc. What are these files. They are quite large and I am wondering if they are necessary.
If anyone has any information, I would appreciate it.

thanks,

 

[DJkarl]

Do you have compact on close turned on for this database? If so I suspect that the compating is not completing properly.

 

[bluedigital]

Do Not

I do not have that turned on unless it is turned on by default. Where do I make that change?

 

[DJkarl]

I do not have that turned on unless it is turned on by default. Where do I make that change?

http://office.microsoft.com/en-us/access/HA102355831033.aspx?pid=CH100948231033#3

 

[bluedigital]

check compact

Yes my compact database option is checked and enabled, I did read your article link and also did a compact and repair, but the additional files are still there. Can I delete these? Each one is almost as large as the original database file.

 

[DJkarl]

Yes my compact database option is checked and enabled, I did read your article link and also did a compact and repair, but the additional files are still there. Can I delete these? Each one is almost as large as the original database file.

Yes you can delete these, these files exist because during the compact repair process a new blank database is created (database1.accdb for example) then the contents of the current database are copied into this blank database then access deletes the current database and renames database1 to the original database name; something was interrupting this process so the contents were being copied into these databases but the delete/rename was never occurring.