Re: Linking a table on Access 2007

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, 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:7018429C-9EAE-4A9B-996C-CE7F0E869AE0@[EMAIL PROTECTED]
>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.
>>
>>
>>