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

conversion access access

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

Conversion of Access 97 to Access 2003 and 2007

ResolvedVersion 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.

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub


3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.