Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot link to Oracle tables

Status
Not open for further replies.
JtheRipper

JtheRipper

IS-IT--Management
Oct 4, 2002
274
GB
HEEELP!!!

Hi there...

I am trying to link certain oracle tables from ms access 2003. When I get the list of Oracle tables, some have quotes around them i.e. CDB."ALLOC_TBL" and I cannot link to them, and the rest that do not have quotes around them i.e. CDB.ORD_TBL.

Why is access only using quotes for some tables, or is it the way the table was created on ORacle?

ANY info will be of great assistance!

Thanks,
J.
 
Status
Not open for further replies.

Similar threads

breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
602
breezett93
breezett93
C
  • Locked
  • Question
Query expression negative to a 0
Replies
6
Views
581
dhookom
dhookom
mhshane
  • Question
Is this the best way to do this query? 1
Replies
9
Views
265
mhshane
mhshane
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
753
mikrom
mikrom
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
1K
MDGarcia
MDGarcia

Part and Inventory Search

Sponsor

Back
Top