By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,468 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Converting Access 2003 to Access 97

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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)
Nov 13 '05 #2

P: n/a
MGFoster <me@privacy.com> 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.
Nov 13 '05 #3

P: n/a

Bob Quintal wrote:
MGFoster <me@privacy.com> 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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.