Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: link table
"search" <gerry_at_village.uunet.be> wrote in message
news:3f9f950e$0$16211$ba620e4c_at_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
>
>
Just create a table in access then
File ->Get external data -> link tables
Received on Wed Oct 29 2003 - 04:32:12 CST