Upgrade from Access 97 to Access 2010

10 pts.
Tags:
Microsoft Access 1997
Microsoft Access 2010
Hi All, I have a client requirement to upgrade our existing application which is developed on Access 97 and running on Win Xp to Access 2010 Win 7. The Access 97 database has file like .MDB, .MDE and .MDW. Can someone, please suggest a way to upgrade form Access 97 to Access 2010.
  • This application involves more than 20 forms and sub-forms with VBA
  • Reports generation
Can someone, please suggest a way to upgrade form Access 97 to Access 2010. Quick Questions:
  • What are the thing to be in handy before migration?
  • Is there anything to be re-create?
  • Performance issues?
  • Any expected issues after post migration?
  • After upgrading to Access 2010, the database extension .accdb or .mdb? if it is accdb then .mdw is supportive?
  • If .mdw security file is not supported with .accdb file  then, is there a way to upgrade acces 97 to access 2010 but the file extension should be .mdb because the .mdw security file is only supportive to .mdbs
  • Access 2010 is compatible with Win XP and Win 7?
Thanks in advance.

Software/Hardware used:
Access 97

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • jinteik
    access 2010 can work on xp and win 7. but i suggest if you want to be safe, better test it on a development machine for just incase if you are worried something might happen
    18,085 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following