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

Resolved · Low Priority · Version 2003

Wed 9 Sep 2009, 16:27 Delegate Jonathan said...

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

Fri 11 Sep 2009, 10:26 Trainer Stephen said...

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

Mon 21 Sep 2009, 09:06 Delegate Jonathan said...

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

	98.7 % recommend us
	More live stats...

Training information:

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