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?
ftenkleyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:
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
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
ftenkleyAuthor Commented:
Found the solution: There is a group policy you can set that prevents Access from converting databases.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
ftenkleyAuthor Commented:
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'
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.