Will I be able to use a program written in Access 97 in Access 20.

[Guest]

I have a payroll program written in access 97 and need to upgrade to 2003 to
be installed on a new computer. Will this custom written program run on 2003?

 

[Guest]

-----Original Message-----
I have a payroll program written in access 97 and need to upgrade to 2003 to
be installed on a new computer. Will this custom written program run on 2003?

.I have been experimenting with a membership file

written in Access 97 and just upgraded to 2003. So far I
have not exprienced any problems. My problems arose when
we went from Windows 98 to XP. All of our birthdates of
those 75 or older converted to the year 2000 something.

 

[BCampbell]

You may need to make some adjustments in the code if you
end up with compilation errors on the new machine. Some of
the older stuff can give you problems, such as references
to DAO, etc. In your code window, click tools, references
to check for missing references if this happens.

 

[John Vinson]

All of our birthdates of
those 75 or older converted to the year 2000 something.

Ummm... No. They didn't.

Your display may have changed (perhaps your Windows Regional settings
are now set to 4 digit years instead of 2 digit years); the fact that
the data was WRONG in your A97 table is now made visible, but I'll bet
you dollars to donuts that the data has *not* changed in the tables.

Birthdates MUST use four digit years. People are living over a century
fairly commonly these days. If you have somebody born in '03 they
might be a year old... or 101 years old, unless you disambiguate by
storing 1903 or 2003 in the table. Access assumes that any 2-digit
year is in the 20th century if it's in the range 30-99, and in the
21st century if it's 00-29.

John W. Vinson[MVP]

 

[stgenethliou]

I have a payroll program written in access 97 and need to upgrade to 2003 to
be installed on a new computer. Will this custom written program run on 2003?

 

[Rick Brandt]

Generally an app that is error free in the code based objects will convert to a
newer version successfully. You might find a couple things that behave
differently enough to bother you, but otherwise it should work.