Using VBA to Convert Access 2000 database to Access 97
Looking for a way to programmatically convert an Access 2000 database
(which contains only tables) to an Access 97 database. Essentially
programmatically doing a Tools, Database Utilities, Convert to previous
version... on an exported file.
If this helps any, here is some background on the issue. I've got an
Access database that is distributed to 20+ offices. Each office exports
their data to a database (only contains 5 tables) to the home office.
The home office then imports all the databases into the home office
system (which is just like all the others) to do some consolodated
reporting. What I'd like to have happen is at the end of the export
routine, I'd like Access to convert the external database.
For those using Access 2000 I've tried distributing with Access 97
runtime. Two problems, one seems silly b/c all the users have Access
2000. Secondly, the users tend to convert the data and don't realize
it's a problem. The home office has Access 97 and needs to not upgrade
b/c of data sharing with other groups of people.
If anyone has any ideas, I would greatly appreciate it.
Sent via Deja.com
http://www.*-*-*.com/
