Hi,

I currently have a data warehouse set up in Access 2000. Is it possible, once the warehouse is updated, to run a subroutine to create a small access 97 database and export a few tables into this new 97 database?????

Thanks
Tim

Tim

__________________
Tim

I don’t think so. As you might know, when you open a 97 db in 2K, it will not allow modifying that db.

What you probably want to do is create intermediate files of the data that you want moved into 97, then use 97 to import those data. (Comma Separated Variable [.csv] files, fixed width text files, etc.)

You might be able to open a 97 db in VBA as a database object, to add, delete or read data. I'm pretty sure you will not be able to create a 97 .mdb, though.

Thanks for the reply. I didnt think about a "third party" option!! Sounds like the best way.

Many thanks

Tim

Tim