Unable to compact database

[chriswatson78]

Hi,

I have created a database with approx ten tables with many queries (make table and append and delete queries). I need to compact this database as I would normally do (usually deal with databases of 500MB and more with no issue) however after over an hour I still get the message 'not responding'. I have tried creating a new one from scrath and get the same issue. Can anyone help please?

 

[Geoff Convery]

I read your other post as well, Chris. Have you tried splitting the databases so that the tables are in one and the code in the other, linked, database. I'm not certain but I suspect that you'll the find that the front ends (the ones with the code in it) will grow exponentially but the back ends will only grow in line with the amount of data appended. If they do need compacting you should also find that they'll compact much more easily as separate entities. If the front ends won't compact you could always keep spare copies and trea the front ends as disposable items!!
As I said I'm not certain that this will work but Ireckon it has to be worth a try!!

 

[boblarson]

Is the database you are trying to compact on a network drive? If so, it can take a lot longer to compact (plus you still run the risk of corruption). If it is, copy the Db to your local machine, compact, and then replace the one on the network share with the one you just compacted.

I have a database that was 200Mb large and it took over an hour to compact on the network drive, but only about 5-10 minutes on my local machine.

 

[Algis Kuliukas]

Access Compact often fails under Vista

Another great leap forward that Vista has given us (excuse the sarcasm) is that it sometimes (but, even more frustratingly, not always) decides to intervene - after about 3 microseconds - when you are trying to do some standard task in Office with the message "Program is Not responding".

I've had this problem when tryin to Compact/Repair and Access database (2003) and also when trying to link and Excel 2007 workbook to an Access data source.

Is it just me that hates Vista? I wish I'd never upgraded.

Algis Kuliukas