Access Project Link Table Error

[Guest]

Hi

Wondering if anyone can help me understand the following error I'm getting.

I've created a Data Access Project in Access 2003, and am trying to link
tables to it from a Data Source I created based on an Oracle DB. But when I
try to add any tables or views it comes up with the following error:

"OLE DB provider 'MSDAORA.1' returned an invalid column definition."

 

[Van T. Dinh]

Are you using MDB file (Access database) or ADP (Access Data Project)?

ADPs are supposed to use MS SQL Server (including MSDE / Desktop enigine)
database as the Back-End but not other database engines like Oracle.

 

[Guest]

Yes I'm using an ADP. I take it that even thought I've created a Data Source
to the Oracle DB, I can't link to it in ADP?

 

[Guest]

Yes I'm using an ADP. I take it that even thought I've created a Data Source
to the Oracle DB, I can't link to it in ADP?
According to the KB it says that it can support ODBC connections.

 

[Dean]

According the Access Help file:
A Microsoft Access project (.adp) is an Access data file that provides
efficient, native-mode access to a Microsoft SQL Server database through the
OLE DB component architecture
You can connect to one of the following SQL Server databases:

a.. Microsoft SQL Server 2000 on Microsoft Windows 2000 or later

b.. Microsoft SQL Server 2000 Desktop Engine on Windows 2000 or later

 

[aaron.kempf]

yeah you should use MSDE or SQL Server; it works a lot better than
Oracle.