ODBC --> Access : "Cannot define field more than once.

[Guest]

I'm using Access 2003 and connecting to a SQL Server (version unknown)
database. I'm able to link or import every table but one. This one table
must have fieldnames that are very close in name because when i attempt to
link or import that table to Access, I the message, "Cannot define field more
than once."

This happens whether I'm trying to link or import. I don't know what the
fieldnames are in the SQL table because I don't have direct access to the SQL
Server, but every other table comes up.

When Access links or imports from an ODBC source and the fieldname does not
follow Access rules, won't Access modify the fieldname so that it conforms to
naming convention? If doing so is causing a duplicate fieldname, what can be
done to further modify the second field's name?

 

[Graham R Seach]

Tim,

I've never experienced that problem, but I recommend you ask the DBA to
create a view, renaming the columns so that you can link to the view instead
of the table.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia