We help IT Professionals succeed at work.

Access 2010 Runtime with 2003 mdb

thebrepp
thebrepp asked
on
2,009 Views
Last Modified: 2012-02-23
Is there a way to disable the prompt to convert and older 2003 mdb when you open it with Access Runtime 2010?
Comment
Watch Question

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks for the reply.  It does continue to prompt for the conversion so maybe it is runtime vs full related on that.  I have to disable the security message too via registry so will try that later today when onsite.  I'll let you know how it goes.

Installation is at least for awhile, a combination of 2003 and 2010.  Until the transition period to 2010 is over, I want to avoid the user issue.  It is a split app so I will also allow the 2010 runtime to convert the user's local front end to see if that kills it.  I'll try registry first though.
CERTIFIED EXPERT
Top Expert 2011

Commented:
I have an Access 2003 MDE that is used by the Access 2007 and 2010 runtime. It have never ask to convert. I also open the Access 2002/2003 format MDB with Access 2007 and 2010 without it every asking to convert.

Are you compiling the front end into a MDE?

If for some reason your front end is not an MDE then I would check the database format to be sure it is in Access 2002/2003 format.
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
I run a mixed Full version 2003/7/10 environment with a mdb front end in Access 2000 format.
Full versions do not ask to convert the file.

Does this happen on every computer, or just some?
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
<Full versions do not ask to convert the file.>

Yes they do. Might not do so on your environment, but full versions of Access will most definitely ask to convert the database.
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
Does that information become embedded in the file and not the computer, then?
I just brought up a new box yesterday and opened our main app (A2000 format) with no prompt.
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
I have no idea how it's stored, but I can guarantee you that the full version of Access will prompt you to convert a file. Happened to me today, in fact, with Access 2010 (full version) opening an .mdb file.
CERTIFIED EXPERT
Top Expert 2011

Commented:
thebrepp, have you tried using an MDE?
CERTIFIED EXPERT
Most Valuable Expert 2014

Commented:
Ah, maybe this is why it doesn't prompt me:  I have set my default file format to be Access 2000 format--so there is no need to update.  I don't know if that is 'settable' on the run-times though

Author

Commented:
This is a runtime version so I am limited on what I can do.  According to last post though, it appears full version does that too.  My day at the client did not allow any real time to get to this issue but will be back at tomorrow.

I will also try the MDE option.  My preference though is a registry setting but the one suggested was not there for 2010 (14).
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
My preference though is a registry setting but the one suggested was not there for 2010 (14).
You have to ADD that registry key and value.
CERTIFIED EXPERT
Top Expert 2011

Commented:
I have tried several PCs with am install of the Access runtime 2010 without any issues with an Access 2002/2003 format mdb and mde. The only registry setting I added was for the trusted location.

I have not been able to get Access 2010 full or runtime to prompt to convert a mdb when it is opened by double-clicking on it.

If the MDB is in a folder where the user has only read only permissions (like the program files on Win 7) then you will be prompted to Save as. This is not the same as convert. See image below.
SaveAs...
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I'm not sure what finally did it as I implemented a few steps.  Originnaly the mdb's were Access 97 with a conversion to 2003 later.  I did a debug compile, compact, etc, ran a routine to stop the security prompt via a registry entry for "safe" folders and all is fine now.

Thanks to all!!
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.