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.
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.
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?
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
