Question Access and Runtime on the same machine

[AlanJ10]

I'm trying to put together a database that is capable of exporting mde files.
The database is currently in 2000/03 format, but will most likely be run on 2007 machines, which will produce 2007 mde (or accde) files.
The people that need to run the mde files, will most likely have Office 2003 installed, so I've been looking at packaging in the Access 2007 runtime for them to run these mde files.
Here are the findings on my machine, which is currently running Office 2003:
1. Install Access runtime, and then the mde created under Office 2007 will open fine.
2. Try to open an old mdb file, this gives an error - "There was a problem sending the command to the program." The file still opens though, but gives an error "The Expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events"
3. Uninstalling the runtime and reopening an old mdb repairs the 2003 installation and everything works fine again.

So, is there a way to install Access Runtime 2007 without destroying my 2003 install?

 

[reddwarf]

http://bytes.com/topic/access/answers/691309-access-2003-access-2007-same-machine

its a lengthy thread...but you are not alone.

 

[AlanJ10]

So I see. I've already had problems with office 2003 and 2007 installed at the same time, but I was hoping that Access Runtime wouldn't cause the same issues.
It's pretty much out of my hands then, either my client will need to have a 2003 machine so they can create 2003 mde files, or they'll just have to tell all their customers that they can only provide the database in 2007 format, so they'll just have to upgrade.

 

[gemma-the-husky]

access 2003 and 2007 do co-exist, but switching between them causes them to reinstall.

now i did find that A2003 mde's didnt run 100% correctly under A2007 - so I ended up producing a 2003 mnde, and a 2007 accde, and supplying both.