Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Access 2007 vs Access 2013

If a user has Access 2007 loaded on their computer but is trying to run an Access database written in 2013, can they load the Access 2013 runtime file on their computer and then will the Access 2013 database open and run just fine?

--Steve
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Theoretically yes,
(Note that there is a lot about this setup that we do not know..., for example you stated the version but not the specific db format, ....mdb, .accdb )
There have been some issue reported when you install a run-time and the full version, on the same machine (especially if they are for different Access versions)

Can we ask why the Access 2007 user cannot run the 2013 file directly?

VM (Virtual Machine) is becoming a popular options when these types of situations are present...

...but let's see what other Experts may contribute...
;-)

JeffCoachman
Avatar of SteveL13

ASKER

The file format is .accdb

"Can we ask why the Access 2007 user cannot run the 2013 file directly?"  -  Apparently there is a compatibility issue but I don't know what it is.
As Jeff alludes to, you should NOT run both the Retail version of 2007, and the Runtime version of 2013, concurrently. You'll have nothing but trouble, and your end user will spin up voodoo spells to plague your life :)

You would be well advised to determine the "compatibility issue" and resolve that.
Great advise!  But what are the differences between 2007 and 2013?  How would I go about making the d/b work on a 2007 computer?
SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I developed but asked in the beginning which version was going to be used.  Was told 2013.  Then surprise!  Is actually 2007.
The VBA references do NOT downgrade automagically
Ummmm ... that's what I said. They'll generally upsize with no trouble, but they do not downsize.
Ummmm ... that's what I said.
Yup, you said it while I was composing mine :)
I'm good, but until I actually commit my first post, I can't know that others are being composed, because I've rarely if ever hit 'monitor this' and then started writing my thoughts :)