G
Guest
any solution to refresh / re-link using vba code (ADO)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Douglas J. Steele
Why does it have to be ADO? DAO is much better suited for that. See the
sample code at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web". It's actually not possible to relink using ADO: you'd need to use
ADOX.
sample code at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web". It's actually not possible to relink using ADO: you'd need to use
ADOX.
G
Guest
i tried this code but there was problem with this statement
Dim dbCurr As DATABASE, dbLink As DATABASE
i am unable to declare/create database object..
Dim dbCurr As DATABASE, dbLink As DATABASE
i am unable to declare/create database object..
G
Guest
how can i use ADOX?
Douglas J. Steele said:Why does it have to be ADO? DAO is much better suited for that. See the
sample code at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web". It's actually not possible to relink using ADO: you'd need to use
ADOX.
G
Guest
i just tried it on another machine. it did work....
but problem is that i have multiple databases at the back end. i have number
of tables linked from these different databases.... how to refresh them all
using this code?
but problem is that i have multiple databases at the back end. i have number
of tables linked from these different databases.... how to refresh them all
using this code?
D
Douglas J. Steele
That means that the database into which you put the code doesn't have a
reference set to DAO.
Go into the VB Editor, select Tools | References from the menu bar, scroll
through the list of available references until you find the reference for
Microsoft DAO 3.6 Object Library, select it and back out of the dialog.
The issue you mention about having multiple backends is something you're
going to have to figure out whether you use DAO or ADOX. You're going to
need to have some way of knowing which table links to which backend, and
then set the Connect property accordingly.
reference set to DAO.
Go into the VB Editor, select Tools | References from the menu bar, scroll
through the list of available references until you find the reference for
Microsoft DAO 3.6 Object Library, select it and back out of the dialog.
The issue you mention about having multiple backends is something you're
going to have to figure out whether you use DAO or ADOX. You're going to
need to have some way of knowing which table links to which backend, and
then set the Connect property accordingly.