conversion access access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Conversion of Access 97 to Access 2003 and 2007 | Access forum

Conversion of Access 97 to Access 2003 and 2007 | Access forum

resolvedResolved · Low Priority · Version 2003

Jonathan has attended:
No courses

Conversion of Access 97 to Access 2003 and 2007

I am responsible for the maintenance of several Access 97 databases, some of which are very complex with numerous forms, code modules etc.

We will soon be changing our Access platform to 2003 or 2007.

Please would you be able to tell me how much effort is typically required in re-writing the Access 97 code to run on the later platforms?

Thanks, Jonathan Hodge

RE: Conversion of Access 97 to Access 2003 and 2007

Hi Jonathon

Thank you for your question

In 2001 I was involved in migrating databases from 97 to 200

From memory there was very little problem in migrating from Access 97 to 2000 in terms of coding, and I imagine the same would apply for 2003 and 2007.

I seem to recall that there was the occasional problem with additional spaces being entered into the code as well as the odd additional line break. This may just have been an issue with the editor that I was using at the time. In any event this was easily solved.

Regards

Stephen

RE: Conversion of Access 97 to Access 2003 and 2007

Thanks very much for your response, Stephen.

Kind regards,

Jonathan Hodge

Thu 17 Sep 2009: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Server loaded in 0.08 secs.