• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 502
  • Last Modified:

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?
0
ftenkley
Asked:
ftenkley
  • 2
  • 2
1 Solution
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now