linking tables using ADO

[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!

 

[Jorge Novoa]

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

Anyway, which is the ADO way?

Regards.

 

[Douglas J. Steele]

No reason why you can't use both ADO and DAO in the same application.

 

[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)

 

[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.

 

[Brendan Reynolds]

DAO is likely to continue to be supported just as long as 'classic' ADO. My
recommendation is to continue using DAO, but for an approach using ADOX
check out the following KB article ...
http://support.microsoft.com/default.aspx?scid=kb;en-us;291264