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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error in linking a table from A Oracle Db using ODBC Driver.

Status
Not open for further replies.
dukbtr

dukbtr

MIS
Nov 26, 2003
40
US
I'm trying to link a Column from an Oracle Database to Access '97 to be able to create reports and queries. I can get all the tables except one and this one is the most important. The Oracle DB is connected to BMC Control-D and holds all the info on job routing. The table is the Metadata table that houses all the info. The error I get is:

Invalid field definition ‘OPEN_FILE’ in definition of index or relationship.

I have tried to link just this table and tried all at once, both attempts result in the same error.

Any Help or Ideas would be greatly appreciated.
THANX
 
Status
Not open for further replies.

Similar threads

BallunarCrew
  • Solved
ODBC Driver Struggles on new computers
Replies
3
Views
968
BallunarCrew
BallunarCrew
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
5K
OCM
OCM
A
  • Locked
  • Question
Print Table attachment
Replies
2
Views
352
andre.meyer
A
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar
ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
1K
ameedoo3000
ameedoo3000

Part and Inventory Search

Sponsor

Back
Top