Error when linking to Oracle Database

[Nunina]

Hi!

I get a "Cannot define field more than once" error when trying to link a table to my Access project.

I have several other tables linked, and there was no problem linking them. Does any of you know what does it mean?

Thanks in advance!

Nunina

 

[vbajock]

I've run into that before using Oracle. In that case it was because Oracle allows longer field names than Access does, and when Access performs the link, it truncates the field names and everyone once and a while truncating field names results in two fields with the same name. The fix is pretty complicated - you have to either rename the field name to something else, using Oracle SQL, or you have to get the DBA to store a view to the table with an alias field name.

 

[Nunina]

Vbajock:

No other possible way? Your suggestion is the only one???

Thanks, anyway... I know he's not going to change it... I'm linking production tables that are going to be read only anyway... hmph! Now I have a problem!

Thanks again vbajock.

Nunina

P/S - Unless you have any other suggestion....

 

[vbajock]

It's the only way. The only other thing I can think of is that perhaps newer versions of Access have increased the field lengths they can handle. I was using Access 97 when I ran into this.

 

[Nunina]

I'm using Access 2000...

 

[vbajock]

That should work. Are you sure you have the latest version of the Oracle ODBC driver? Here's the troubleshooting page for that:

http://otn.oracle.com/software/tech/windows/odbc/index.html

In Windows, go to ODBC admin, click the Drivers tab and compare what you have to the page.

Or, if your using Microsoft drivers, you might want to look at this page:

http://support.microsoft.com/defaul...port/kb/articles/Q244/6/61.ASP&NoWebContent=1