connect to access 2 tables

[damo]

Can anyone help here?

Im looking for some code to connect an Access 2000 app to tables in a version 2 app to retrieve some similar fields.
Ive declared a DAO connection and recordset, but Im not sure whether to set the record set to a new DAO or ADO.

Ta in advance.

 

[skiphooper]

Damo,
Access/2000 supports Access 2.0 file formats for Import, Export, and Link.
You should not have much trouble working with it.
Once the 2.0 tables are linked you should be able to use it like any other table.

here's the Microsoft link for the formats:


http://sup port.microsoft.com/support/kb/articles/Q180/1/05.ASP?LN=EN-US&SD=gn&FR=0&qry=link%20Access/2%20into%20Access/2000&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

Hope That Helps
Skip


[This message has been edited by skiphooper (edited 03-21-2001).]

 

[damo]

That WOULD be okay, but it's a runtime app, the user doesn't have Access 2000 to allow me to go in and link to the tables, so it's got to be connected within the system...

cheers for the app you sent by the way.

 

[skiphooper]

Damo,
If I understand you correctly, the Access/2.0 users need to get data from the Access/2000 App.
If that's the case than ( and I could be wrong,)
But I think that's not going to happen unless you export the 2000 data, and then import it to your 2.0 app. just like Access/ 95 and 97 can't read 2000 db's I'm sure 2.0 apps cannot read 2000 dbs.
If I'm wrong, someone please reply and correct this.

Skip

 

[damo]

The other way about Skip,
Access 2000 to read from 2.0, but via code, cannot go in and manually link tables.
Im just about to try using the SQL 'IN' clause, see if that works...