asked on

Prevent conversion of Access 2003 database

Could you prevent Access 2007 from converting a .mdb (Access 2003)?

When opening a .mdb, Access 2007 asks if you wish to convert the dB to the new .accdb format. Is there a way to prevent Access 2007 from suggesting the conversion?

Patrick Matthews

Try changing the default file type to either Access 2000 or Access 2002-2003. (I go with the Access 2000 format for backward compatibility to older solutions I and my co-workers have created and still maintain.)

This Microsoft page describes how to do this: http://office.microsoft.com/en-us/access/HA100210701033.aspx

Scott McDaniel (EE MVE )

Note that if you have coworkers who are still running Access 2000 you should also maintain a version compatible with them. If you convert to the 2002-2003 format, users still running 2000 will not be able to use the file.

Access 2007 should only prompt you one time to convert - try opening the database in 2007 (and selecting No when asked to convert) before deploying to your coworkers. I'm not sure you can supress the messae, but then I've never really tried to do so.

ASKER CERTIFIED SOLUTION

ftenkley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott McDaniel (EE MVE )

Can you please let us know the Group Policy you found that resolved this? This question is asked fairly often and there has yet to be a good answer, and if you found one it would be much appreciated.

ftenkley

ASKER

Start the Group Policy Management Console (gpmc.msc). Right click on the container that you wish to set the policy for en click 'Edit'.

In the Group Policy Management Editor, Navigate to 'User Configuration\Policies\Administrative Templates policy definitions\Microsoft Office Access 2007\Miscelanious\Do not prompt te convert older databases'