link table

From: search <gerry_at_village.uunet.be>
Date: Wed, 29 Oct 2003 11:23:09 +0100
Message-ID: <3f9f950e$0$16211$ba620e4c@reader3.news.skynet.be>

Each time I open my access db , I wanted to link an oracle table via odbc. I can't find the way and the code to do this....

I tried to open a form with the startup of the DB and on the load event of that form
program the code to link the tabel

DoCmd.TransferDatabase acLink, "ODBC Database", _ "ODBC;DSN=data source name;UID=user;PWD=password;", _ acTable, "Schema.tablename", "localtablename" , ,True

But it won't link my table?

Any help would be great!

Gerry Received on Wed Oct 29 2003 - 04:23:09 CST