MS Access Runtime 2000 and MS Access 2010

[clogan98]

We have a critical database that a number of our staff persons use. It is extremely old, but it still works. It uses MS Access 2000 Runtime.



The problem is that we use primarily Office 2010, and we have been unable to get Access 2010 to run on a machine that has the Access 2000 runtime installed, and vice versa. If I install the Runtime, 2010 doesn't work. If I install 2010, the runtime doesn't work.

Because this database is so old and critical, we have been going without, and I am tired of being unable to use Access 2010. We cannot use any other runtime with it - we have tried and it always fails. Does anyone have any advice or suggestions as to what we can do to get this to work?

This may be a red herring and not relevant, but we recently got a new computer that came with Office 2013. I was able to get both the 2000 runtime and Access 2013 on the same machine and they both work fine. Unfortunately, every other machine has Office 2010 on it, and don't have the budget to upgrade.

Any help or advice would be greatly appreciated.

[ItsMe]

I usually use one version of Office on any given machine. Can you upgrade the DB to 2002-2003 format?

[clogan98]

Unfortunately not. We are in the beginning stages of replacing this beast, but that may take more than a year. There simply has been no way to change the existing database in access 2000. Every time we try something, it either blows up or something stops working.

[ItsMe]

It sounds like a Lifecycle issue. I do not think 2013 supports the mdb format but I believe 2010 does for 2002-2003 file format.

I would be looking at getting it into a 2002-2003 format using an XP machine and Office 2003. You know better than I do, how difficult that may be but, I believe it is the best approach. I would never have ventured down the path of using 2000 RT on newer machines so I may not have the appropriate insight to offer guidance.

[clogan98]

So the case gets weirder. So I have a machine running Win7 and I can get the two working together just fine. The person I want to provide this capacity has the same exact machine (Dell OptiPlex 390) with the exact same version of MS Office. So it works fine on my machine but errors out on her machine. Yikes. If anyone has any ideas where to look, what might work etc. I am desperate and open to trying just about anything.