Also, did you take a look at the names of your indexes and primary keys on
SQL-Server?
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:u2gYzkBTJHA.5812@[EMAIL PROTECTED]
> 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.
>>>
>>>
>>>
>
>
|
