Linked Oracle Table in Access

G

Guest

A MDB file has oracle tables linked to it. These linked tables have no DSN
information on it and works without a DSN. After adding the TNSNames
information for oracle server, I was able to access the linked tables in this
MDB file by double clicking the table.

Any thoughts, How database access is possible without using DSN for linked
tables?
 
G

Guest

These linked tables have built in ODBC info.

ODBC;DRIVER={Oracle in
orant9i};SERVER=GMSU1;DBQ=GMSU1;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=Lo;BAM=IfAllSuccessful;MTS=F;MDI=Me;CSR=F;FWC=F;PFC=10;TLO=O;;TABLE=ABC.TRAN_DATA_CODES

But I am not able to modify this ODBC description in design view of this
linked table. Please help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top