The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Conversion of Access 97 to Access 2003 and 2007

Resolved · Low Priority · Version 2003

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

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

For upcoming training course dates see: Pricing & availability

ReplyFri 11 Sep 2009, 10:26Trainer 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

ReplyMon 21 Sep 2009, 09:06Delegate 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.

Access articles

· How To Successfully Design An Access Database For A Paying Client
· Access Database Optimization: First Normal Form
· What's In A Name? Creating A Company Personnel List Using Microsoft Access
· Microsoft Access and Customer Surveys
· Discover How To Link An Excel Spreadsheet To An Access Database

Please browse our web site to find out more about
access+course and other Microsoft training courses.

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips

How do you embed videos into powerpoint? That way, when i share my presentation the person recieving it can watch the videos also?
Many thanks, Alex.