Covert A97 to 2K

[AlCamp]

I have been developing a very large database application in Access97 for
several years now.
The database is split, the front end consists of ~150 forms, ~150
reports, and ~70 queries. It's very large, and some of the forms are very
complicated... more like "mini-applications" than just forms.
The back-end consists of about 35-40 tables.

I would like to convert to Access 2K, but I don't want to do the
conversion in "one fell swoop". (ex. convert the Sales functions, then the
Production, etc, etc...)
Can an Access2000 front-end link to an Access97 back-end?
This would allow the users to continue using A97 during the 2000
conversion/testing process.

Any info, guidance, warnings, etc... gratefully accepted.

Thanks,
Al Camp

 

[Douglas J. Steele]

Yes, an Access 2000 front-end can link to an Access 97 back-end.

 

[AlCamp]

Doug,
Thanks a lot for that info. That will really big a big help in this very
large conversion.
Whew!!
Al Camp

 

[david epsom dot com dot au]

You may wish to set a string property for SubDataSheet Name on
each table in the A97 BE. This is not a default property in
A97, so you need to use code to create and set the property.

If this property exists, and is set to '[None]', it prevents
A2K from automatically loading related tables when you open
a table. The process of loading related tables is something
that slows A2K down, when compared to A97.

For more information, see Tony's Performance FAQ:
http://www.granite.ab.ca/access/performancefaq.htm

(david)