Re: link table

Hi Chris ,

I know that I can manually link the table BUT I wanted to do this a "proper" way.

I use this code :

DoCmd.TransferDatabase acLink, "ODBC", _

    "ODBC;SERVER=name;DRIVER={Oracle in
Ora92Home};UID=username;PWD=password;" _

    , acTable, "Schema.table", "LocalTable", , True

I works fine but I have 2 obstakels :

1. The system asked the service name (username and password are fullfilled now)
2. after that , the system asked for select a unique record ID.

If I can pass those 2 arguments in the string above it would be great.

any help welcome

Gerry

"Chris" <cs123_at_telstra.com> schreef in bericht news:MGMnb.169732$bo1.19434_at_news-server.bigpond.net.au...
>
> "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 - 09:28:31 CST