Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 10th, 2008, 06:43 PM
Authorized User
 
Join Date: Feb 2007
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access database spawning other databases!

I have an Access 2007 database, containing 1 table and some code, which processes a series of .csv files contained in a folder and inserts their data into this 1 table.

I have set the database to compact on close. Other than this, I have set no other database options.

For some reason, whenever I close the database, another database by the name of 'Database' is spawned in the same location and of similar size. If I subsequently open the database and close it, it spawns another database 'Database1' and so on.

What and why are these additional databases being created?

Any help would be much appreciated!

Thanks, Keith

 
Old November 11th, 2008, 04:44 AM
Authorized User
 
Join Date: Feb 2007
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Bit of extra information: If I un-check the compact on close option, no additional databases are created when I close the main database.

Also a bit of information on these 'cloned' databases: I notice their file type is 'Microsoft Office Access Database', as opposed to the main database, which is 'Microsoft Office Access 2007 Database'. Also, if I open any of these spawned databases, they are identical in content, including VBA code, to the original.

I have created other databases in the past, which compact on close and don't do this, so why is this happening now?

 
Old November 11th, 2008, 06:22 AM
Authorized User
 
Join Date: Feb 2007
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Default

After trawling through the internet, I found someone with the same problem. It seems as though the locking file Access generates when a database is open can sometimes not close quickly enough when the database itself is closed and compacts. Therefore, another database is generated. This could be a side effect of having the database on a network drive, which both myself and this other person have.

Seems a bit of a daft oversight for such an established piece of software. Can anyone confirm this or why it happens?

 
Old November 22nd, 2008, 12:49 AM
Registered User
 
Join Date: Nov 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have noticed that same thing, even though I am using 2003. On my desktop, there is no problem, but on the network, the same issue. I haven't asked the IT dept., however, I think that Access may not have Delete rights on the network.

Whenever you compact on close, Access creates a new database and all of your objects are copied to it. It then deletes your original copy and renames the new db with your old db's name. If it can't delete the old it just leaves both.

You can watch this happen if your db takes long enough to compact. As it is compacting, go to the folder where your database resides, and you will see it in progress.


Allan




Quote:
quote:Originally posted by Keith Smith
 After trawling through the internet, I found someone with the same problem. It seems as though the locking file Access generates when a database is open can sometimes not close quickly enough when the database itself is closed and compacts. Therefore, another database is generated. This could be a side effect of having the database on a network drive, which both myself and this other person have.

Seems a bit of a daft oversight for such an established piece of software. Can anyone confirm this or why it happens?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Synch 2 access databases raguapk Pro VB 6 2 December 11th, 2007 11:27 PM
MS Access Databases dmoffice VB Databases Basics 1 October 10th, 2006 03:37 PM
Updating Access Databases rsm42 ASP.NET 1.0 and 1.1 Basics 11 September 11th, 2006 02:15 PM
How to connect Access to diff databases catkins Access VBA 4 April 24th, 2004 12:53 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.