Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 746
  • Last Modified:

Prevent Access 2010 from converting Access 2003 .mdb file

Most posts talk about converting .MDB files to the new format for Access 2010. I would actually like to PREVENT that and keep the database in Access 2003 format (.MDB). Furthermore, I would like to prevent any users from converting the database by mistake. Is there some way to keep an .mdb file locked from any conversion to a newer format?
0
Alex Scarfone
Asked:
Alex Scarfone
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
Then don't give them an MDB file...
;-)

You should be distributing an .mde file (cannot be saved as another format)
0
 
Jeffrey CoachmanMIS LiasonCommented:
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
I agree with boag2000. If the database is properly split and the front end is compile into a MDE then the front end database CAN'T be convert.

I still keep all my database in the MDB format even with Access 2007 and 2010. I still create an MDE with Access 2007 or 2010. The MDE is not backwardly compatible. An MDE created with 2007 can't be used with Access 2003.  I have an app that where the MDE is created with Access 2003 and used with 2003, 2007, 2010, and 2013 witout every getting converted.

I do not have any application in Access that need the new features in ACE (.accdb) so I don't convert to the new format.
0
 
Alex ScarfoneInternal IT ManagerAuthor Commented:
It seems that it didn't automatically convert the version, so all is OK
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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