Linking a table on Access 2007

[Jimmy Jones]

I am building an application with a SQL Server 2005 DB Back-End and a SQL
Server Express Front End.

There is a table on the Front-End that is automatically updated by the
server hositng the back-end DB.

I have build an ODBC connection to the front end DB on the PC that has the
SQL Server Express DB on it.

I am trying now to set up a linked table in Access 2007 to a table called
dbo.tblFEStatus in the SQL Server Express DB that I have an ODBC connection
to.

When I do this I get an error that says 'PK_dbo.tblFEStatus' is not a valid
name. Make sure that it does not include invalid characters or punctuation
and that it is not too long.

The table name is not PK_dbo.tblFEStatus it is just dbo.tblFEStatus. where
is that PK_ coming from and why is Access 2007 not able to connect? I was
able to do this in 2003.

 

[Sylvain Lafontaine]

From where does this name 'PK_dbo.tblFEStatus' comes?

On SQL-Server, indexes and constraints - like a primary key - have each an
unique name. I suppose that you have given the above name to your primary
key constraint (or indexe). Is so, rename it without using a point "."; for
example 'PK_dbo_tblFEStatus' .

 

[Jimmy Jones]

I have no idea where this name is coming from. There is nothing in my SQL DB
with that name. It's as if Access 2007 is appending a PK_ to the name of the
table but I don't know why it is doing that.

 

[Sylvain Lafontaine]

With what driver are you trying to etablish the ODBC connection? Did you
try with the latest ODBC driver for SQL-Server 2005 such as the Native ODBC
Driver for SQL-Server 2005?

http://www.connectionstrings.com/?carrier=sqlserver2005

 

[Sylvain Lafontaine]

Also, did you take a look at the names of your indexes and primary keys on
SQL-Server?