|
Home > Archive > MS Access data conversion > April 2005 > Converting from Access 2003 to Access97
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Converting from Access 2003 to Access97
|
|
|
| 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 2005-04-07, 8:04 pm |
| 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.
--
Brendan Reynolds (MVP)
"Dave" <davidclark@mail.com> wrote in message
news:1112885002.936300.100290@l41g2000cwc.googlegroups.com...
> 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
>
|
|
|
|
|