linking tables using ADO

J

Jorge Novoa

Hello everyone,

I need to link tables programatically, I've already got the code using DAO,
but.. I'd like the ADO way, could anyone help me?

thanx!
 
J

Jorge Novoa

OK, but...
Sooner or later we'll have to leave DAO in the past.

Anyway, which is the ADO way?

Regards.
 
D

david epsom dot com dot au

The 'ado way' would be to create a view (a query) instead
of a linked table. You create views using DDL like this:

..execute "CREATE VIEW view [(field1[, field2[, ...]])] AS selectstatement"

selectstatement would be something like this:

Select * from [database].


(david)
 
P

Paul Overway

ADO is no better than DAO in respect to working within an Access
application. DAO is not going away anytime soon...hell, its part of the
Windows OS! If anything, ADO is more likely to be deprecated first. Your
comment suggests a bias based on misconceptions.
 
Top