Thursday, July 26, 2007

AVG Free and Access

AVG Free automatically scans MDB files when you open them, and this cannot be turned off in the Free edition. Even on a fast PC, it could take 20-30 seconds depending on the size of the database.

This presents itself in two ways:

1. You are using Access 2000-2003, just opened the db moments ago, and you want to do a quick compact & repair. Access tells you either "Cannot open database '(database name)'. It may not be a database that your application recognizes, or the file may be corrupt." or "Cannot open 'database name', file already in use."

If you wait a little while and try it again, the compact & repair succeeds.

2. You are using Access 2007 and wish to convert a 2000-2002 format MDB into the new ACCDB format. Access tells you "You attempted to open a database that is already opened exclusively by user 'Admin' on machine '(machine name)'. Try again when the database is available."

In this case, waiting does not work. You need to close, and then re-open the database while holding the Shift key, to bypass any AutoExec or startup code. Then, you wait for little while and repeat the Convert and it will succeed.


Anonymous said...

thanks, very useful!!


Beth said...

Thank you! Thank you! Thank you! I have searched for hours to find a way to get my 2002-2003 DB unlocked so it could be converted to 2007. Nothing from MS was of any use whatsoever! This certainly provides motivation to regulary read your blog! Again Thank you!

Deniz said...
This comment has been removed by the author.
Deniz said...

You are the only one who solved that problem, thank you.

Anonymous said...

I echo Beth above -- I searched hundreds of sites and all responders (some MVP's) retorted something like "well somebody has it open".
Thanks again,
d'Arcy in Canada

Anonymous said...

My savior! Excellent solution. This worked!

the dirty fix said...

That was great. The shift key. Amazing. thanks/Alan

Unknown said...

I can't believe it worked. Thanks very much.

Anonymous said...

It's got to be repeated... you're the only person on the web that helped solve this nasty issue.

Thank you!