Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: link table
On Wed, 29 Oct 2003 10:32:12 GMT, "Chris" <cs123_at_telstra.com> wrote:
>
>"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
>
>
Actually, it's just File -> Get External Data -> Link Tables.
Strike the phrase "Just create a table in access then"
None of which as a thing to do with Oracle. Received on Wed Oct 29 2003 - 08:37:10 CST