Re: Linking a table on Access 2007

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" wrote:

> 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' .
> 
> -- 
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
> 
> 
> "Jimmy Jones" <JimmyJones@[EMAIL PROTECTED]
> wrote in message 
> news:40C6B99A-073A-4FB4-8330-C1C9DAFE8C9B@[EMAIL PROTECTED]
> >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. 
> 
> 
>