Automatic conservion or importing to Access 97 from Access 2.0 MDB
John & Johan!
I found that linking the V2 tables to my database is a great idea!
Thank you both!
Bill N.
--------------
Bill-
If you can get to the V2 database over a network, you can directly attach
(link) those tables into an A97 application. If you only need to do
periodic imports, you can use the TransferDatabase command in VBA or in
macros.
HTH...
--
John Viescas
author, "Running Microsoft Access 97"
http://www.amazon.com/exec/obidos/ISBN=1572313234/
Quote:
>Bill,
>Just attach the Access 2 tables to your access 97 database. That way you
can
>work with them as if they are a part of your database, but they remain in
>the access2 database.
>Johan
>>I hope that someone has done this before:
>>I am using an ACCESS 2.0 database created by a 3rd party to create
>>additional reports for the management. Data were updated daily thru the
>>vendor's program installed in a Win 3.1 machine. I would like to be able
to
>>update Access97 database using tables in the other's database (ACCESS
2.0 -
>>16bit) automatically. I have copied and converted the database to Access
97
>>and added forms & reports to it. I need a routine to access the 2.o tables
>>and update my tables based on the criteria (append from, mostly)
>>I understand that Access97 can read a 2.0 database but can't modify it. I
>>hope that you can shw me how to do it using VBA.
>>Thanks
>>Bill N.
