Linked Oracle Table in Access

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Access 2003 not linked to Oracle 11g 3
Setting the primary key when using DoCmd.TransferDatabase acLink 3
Error 3298:More than one table exists with same name 2
Oracle linked tables 3
DSN-less switch from SQL Server to Oracle 5
Linked Table Issue to Oracle 1
how to reconfigure Table links in MS Access 2003. 3
Link SQL Server Table to Access 2

Back
Top