Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2003-11-05 : 14:10:46
|
| Does any one have example scripts to automatically link tables using ADO not DAO? I am trying to get rid of the *(#@%^$! issue with tables starting with dbo_XXXXX. |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-11-05 : 14:30:16
|
| Scott -- did you see my response to your question? Just use my routine or something similiar and add a VB reference to DAO. Any reason why you CAN'T use DAO ?- Jeff |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2003-11-05 : 14:47:00
|
| I don't have DAO installed. ALso, DAO is on its way out. I have more knowledge with ADO. |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2003-11-05 : 14:49:31
|
| I have created a VBA routinte using ADO to connect to the SQL server DB and select the user tables from sysobjects. Know all I need is the syntax to create the linkes table. |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-11-05 : 14:59:20
|
| You can't link tables via ADO. Plus, I don't get what issue you mean. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-11-05 : 15:03:30
|
quote:
ALso, DAO is on its way out
yep, but if you use Access you are still using DAO whether you have a link to it in VB or not.type this in, in the debug window:?currentdb.name"Currentdb" is a DAO database.anyway, even w/o a reference to DAO, you can still do this:dim t as objectfor each t in currentdb.tabledefs t.name = mid(t.name,5)nextor something like that.- Jeff |
|
|
|
|
|
|
Linked tables using ADO