Upgrade Access 97 mdb to Access 2010 mdb/mde? Experiences?

I have a really old, Access 97 app which needs to be modernized. I'd like to make something more modern, but it would likely be a bit to expensive to rewrite the whole applikation to a real winapp (or webapp). So the idea now is to upgrade to Access 2010. However we tried the automatic upgrade tool, and that br开发者_如何学JAVAoke. The app is rather big with 40+ forms and modules.

I just want to know if someone have a real world experience from a similar situation and/or has any advice as if it's a likely dead end to try to upgrade. Or better - should be possible.

Also - I might need some help, if someone can advice of a company that are good at these kinds of tasks.

There have been a lot of changes between Access 97 and 2010. Each upgrade (97 to 2003, 2003 to 2007, etc.) had quirks that you needed to be aware of. The conversions weren't usually simple tasks, especially when you had a complicated database with lots of things going on. Taking the leap from 97 directly to 2010 will be almost impossible in your situation. However, it can be done if you take it slow and address the problems at each stage. The issue is that it might take more time than you are willing to give to it.

In my search for answers for you, I came across companies that did this type of conversion for you. This, to me, is one more indication that this isn't something you just let a wizard do (otherwise, who would pay for the service). Here is one of the companies I found:

http://www.consultdmw.com/convert-access-97-database.htm

I've never used them so I'm not endorsing them. I'm just using them as an example.

There are also resources out there of people that have walked down this path and shared their experience. These might be valuable to you in determining if you want to go down this path and if so, what to look out for. Here is an example:

http://chentiangemalc.wordpress.com/2011/03/24/upgrading-access-97-application-to-access-2010/

I don't have Access 2010 and don't know about that automatic upgrade tool you mentioned. With Access 2007, I can import objects into a new empty MDB from an earlier version database in stages.

First import tables, and verify data imported correctly.

Next import standard and class modules. Run Debug->Compile, and fix any errors the compiler complains about. Might have to add references as needed.

Then import the forms and run Debug->Compile again.

Same for reports, if any.

Best case, you would have few fixes needed to get it running with 2010. If the amount of fixup work is unreasonable, then consider farming it out to a service.

But I suggest you at least try the manual import method first. You shouldn't have to invest too much time to see whether it's worthwhile to continue.