Converting Access 2003 to Access 97

[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

[MGFoster]

Dave wrote:

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....

Use the Tools > Database Utilities > Convert Database > To Access 97
File Format.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

[Bob Quintal]

MGFoster <[e-mail]> wrote in
news:PS*****************@newsread1.news.pas.earthl ink.net:

Dave wrote:

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....

Use the Tools > Database Utilities > Convert Database > To
Access 97 File Format.

This only works if the developer has stayed away from decimal
type fields which Access 97 doesn't support and access 2003 is
too stupid to change to long or double..

--
Bob Quintal

PA is y I've altered my email address.

[Dave]

Bob Quintal wrote:

MGFoster <[e-mail]> wrote in
news:PS*****************@newsread1.news.pas.earthl ink.net:

Dave wrote:

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....

Use the Tools > Database Utilities > Convert Database > To
Access 97 File Format.

This only works if the developer has stayed away from decimal
type fields which Access 97 doesn't support and access 2003 is
too stupid to change to long or double..

Hey, yeah actually I wasn't even thinking about that. Sometimes I get
too buried in code to think about looking at menu options. But
actually I found that if I make a database from ACC2003 like this:

Set dbx = DBEngine(0).CreateDatabase(dbxname, dbLangGeneral,
dbVersion30)

And then write tables to it like this:

DoCmd.TransferDatabase acExport, "Microsoft Access", dbxname, acTable,
"CPIINPUT", "CPIINPUT_TEMP", False

That it reads just fine into my ACC97 application...

Dave