Re: Linking a table on Access 2007

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:40C6B99A-073A-4FB4-8330-C1C9DAFE8C9B@xxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • A pk is *both* a physical and a logical object.
    ... Primary key is a logical constraint. ... but SQL Server does not allow you to create a unique or primary ... constraints) by indexing is purely *platform dependent*. ... PKs are part of the ANSI SQL standard *for db implementations*. ...
    (comp.databases.theory)
  • Re: SQL Server error when attempting to delete a record
    ... What version of SQL Server have you got? ... recordto be affected and execute this command based on the Primary Key ... Script the table's definition to a file (including constraints, indices, ... of the database, factors like that. ...
    (microsoft.public.sqlserver.server)
  • Re: Constraints: disable / enable constraints issue
    ... You can use ALTER TABLE to disable a foreign key. ... primary key, since it uses a unique index. ... Columnist, SQL Server Professional ... constraints, in particular primary and foreign keys? ...
    (microsoft.public.sqlserver.server)
  • Re: Unique fields in table design
    ... Otherwise, the multi-column primary key ... The so-called 'surrogate key' ... Using UNIQUE or PRIMARY KEY constraints for ... INSERT INTO SalaryReviews (employee_nbr, salary_start_date, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Clustered Index question
    ... Columnist, SQL Server Professional ... If I keep the primary key, ... >select packet_time,packet_data from packet where ... >have the clustered index (either on PACKET_TIME or on ...
    (microsoft.public.sqlserver.programming)