Problems compacting

[knightwest]

Hi, I have a problem compacting a database. i used to do this all the time at my old job, yet here at my new company, all I get is the usual blank Access screen, the sandtimer mouse icon, and if I select any other program in Windows and the switch back to Access, it crashes "MS Access (not responding)

Any ideas what might be happening here.

 

[KeithG]

Is it a large db containing alot of objects?

 

[knightwest]

Thanks for replying.
Not really, one contains 4 tables and about 10 queries and is about 54MB.
The other contains two tables and 2 queries and is about 196MB.

At my old job I used to compact very complex dbs at about 1.8GB with no problem at all.

I don't think I am doing anything wrong or stupid.

 

[KeithG]

Are you the only user in the db?

 

[GaryPanic]

try coping this on to a local PC and doing it - see if that works if so - dodgey network settings
g

 

[knightwest]

Hello all, thanks for your replies.

I have found that often when Access is "not responding" it is in fact not hung. I found this by checking the Task Manager, the process was still running.

So i just left it long enough and once the process actually started is quite quick.

 

[Dennisk]

I've experienced the same when compacting. A blank (grey screen) and if you click the close icon I get the message Access is not responding. However if you drag the mouse into that part of the screen where the db is and it turns into an hourglass then access is still compacting. So as the other posters have said be patient or copy to a HD, compact then copy back to network.