runtime A2K3

[Guest]

I developed a database in A2K3 then discovered it would be installed under
runtime, not full A2K3.

Data collection in the field uses a scaled down version of the same database
in A97 on a laptop running A97.

How can the users (in runtime A2K3) import a table or query from the A97
database and append the records to a table in the A2K3 database?

Would it be possible to collect the field data on a hand held PC and
synchronise this with the same A2K3 database in runtime A2K3 ?

Please note that I don’t have access to a computer without Access installed.

 

[Sylvain Lafontaine]

You can use ADO objects to open the A97 database. From there, it's easy to
read the data from a recordset and append them to your A2003 database.

If you want to, you can even make direct calls to DAO to open the A97
database. I can find the documentation about this somewhere is you need to;
however, it will be probably easiest for you to go with ADO then with DAO.

S. L.