Converting from Access 2003 to Access97

[Dave]

Hi,

I wrote a VBA program to read and process data from an ODBC source and
put it into an Access database. I want to make the program into an MDE
file and run it on systems with Access 2003. So I have to work in
Access 2003 to do this. The problem is that the database that is
created by my program will have to be imported into an application that
only handles Access 97 .mdb file formats. I am wondering if there is
any way to do this. I only have to export the tables, but I need to
preserve the table properties. I was thinking about doing some type of
generic export from ACC2003 and then running some kind of VB script to
convert it into ACC97.... Maybe there is a better way....

Thanks for any help.
Dave

 

[Brendan Reynolds]

Use two Access files - an Access 97-format MDB containing only the tables,
and an Access 2002/2003-format MDE containing your application objects and
code and links to the tables in the Access 97-format MDB.