Access 2003 Application using Access 2010

[clipper]

Hello everyone,
Hope someone can help.

I developed a front end /back end Access 2000 application (using Access 2003) some time ago for a friend that runs a small local business.

On my desktop I have Access 2003 installed and on my laptop I have Access 2007 installed. Both machines have Windows 7.

My problem is that my friend's PC has a fault and he has replaced it with a new Windows 7 PC and Office 2010.

I don't have Office 2010.
He wants the Access application to run on his new PC (with no extra features).

What's the best way to deal with this?
I can't borrow his PC as it is heavily used.
I had thought about converting the application to Access 2007 in the hope that Access 2010 will run it- Would this work?

Any ideas very gratefully received!

Thanks

 

[boblarson]

So has he tried it on 2010? It is possible to run a 2000 version on there. It would really depend on the database as to what might or might not work.

 

[worthmi]

I would try testing the DB on 2010; where I work we went from 2000 to 2010, and most of the databases ran fine unchanged. You might not need to do anything.

-Ed

 

[clipper]

Thanks Bob and Ed
I just tried running the application on Office 2007 and it fails.

I link some tables in the back end database to the front end by VBA code when the program starts up.
This works fine when using Access 2003, but I think this is where the program is failing in Access 2010.

Is there a website that describes known problems using Access 2003 code on Access 2010?

Thanks again

 

[boblarson]

This works fine when using Access 2003, but I think this is where the program is failing in Access 2010.

Is there an error message or something that is coming up?

Is there a website that describes known problems using Access 2003 code on Access 2010?

Not that I know of.

 

[Guus2005]

I had the same problem. I changed the reference to the Excel Object and everything worked fine.

Nowadays i create and maintain access 2003 databases with my Access 2010 version while the customer uses Office 2003 with no errors.

HTH

 

[gg_govind]

We are in a shared environment where one part of the team has access 2003 and the other part has access 2010. any suggestions on how both the teams can work on the same MDB file?

 

[boblarson]

We are in a shared environment where one part of the team has access 2003 and the other part has access 2010. any suggestions on how both the teams can work on the same MDB file?

1. The database must be split (backend - tables and frontend - everything else) with the backend in a shared location and a copy of the frontend ON EACH USER'S machine.

2. As long as you use an MDB file and not one of the other newer ACCDB file formats, you should be okay doing the development work in either 2003 or 2010, but you may need to keep two versions - one with the Ribbon stuff and one without. But it may not be necessary, but you should test thoroughly.

 

[gg_govind]

Thanks Bob,

I guess any of the existing queries would work in 2003 formats will work in 2010!. I will make arrangements for database split