Linking a table on Access 2007

  • Thread starter Thread starter Jimmy Jones
  • Start date Start date
J

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.
 
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' .
 
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.
 
Also, did you take a look at the names of your indexes and primary keys on
SQL-Server?
 
Back
Top