This SQL statement works and connects on the fly to an external database:
SELECT * FROM ([ODBC;DRIVER={Microsoft ODBC for Oracle};SERVER=servername;UID=myID;PWD=myPassword].ownername.ExternalTable
I have lost the source example for this code. I want to link to an external Access database usin...
I have a simple VB6 application that opens an Access 2000 DB and runs two macros.
When someone is logged on, I can set a scheduled task to run the application as anyone with a proper network password and it works fine.
But when no one is logged onto the computer and the scheduled task is set...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.