Developping for Access 2000 using 97 - possible or upgrade necessa

[Guest]

I am currently using Access 97, but I was recently asked to develop an
application for a company running Access 2000.

1. Will I have to upgrade or would it be possible to develop in 97 and then
convert the application to 2000 after I upload it to their system?
2. if I have to upgrade, should I upgrade to 2000 or to 2003?

Best thanks in advance for any suggestions,
Martine

 

[Rick Brandt]

I am currently using Access 97, but I was recently asked to develop an
application for a company running Access 2000.

1. Will I have to upgrade or would it be possible to develop in 97
and then convert the application to 2000 after I upload it to their
system?
2. if I have to upgrade, should I upgrade to 2000 or to 2003?

Best thanks in advance for any suggestions,
Martine

I develop in 97 and convert up for distribution all the time. No reason to go
any higher than 2000 since the higher versions can use a 2000 file just fine.

 

[Guest]

But you need to TEST in Access 2000.

For example, parameter queries that work in A97 sometimes
crash in A2000.
Look at the Alan Browne website for more information
on A2000 anomalies

(david)

 

[Van T. Dinh]

IMHO, you should use A2000 or later to develop the database for your client.
There are a number of new objects / references that have been introduced in
A2000, e.g. CurrentProject, Round(), InStrRev() that are not available in
A97.

Both A97 and A2000 have pass their main-stream support from Microsoft
(extended support is still available) so you should go for A2003. A2003 can
create database in A2000 file format (in fact, A2000 file format is the
default file format for A2003 software).