Re: Problem using linked tables instead of ADP

Hi Monte

> Have you linked the table such that Access recognizes the primary key?
>

As far as I know, yes? I wasn't prompted to select a primary key and looking
at the table design from within access shows the primary key present but as
text instead of number.

Cheers

Mark


.

Relevant Pages

  • Re: Relationship question
    ... the design as a separate identity. ... CONTACTS_ID (Primary Key - Autonumber) ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Dynamic column specification in table update
    ... Pro SQL Server 2000 Database Design - ... > primary key should be made up from your data. ... >> The only excuses tend to fall along the lines of laziness or ignorance. ...
    (microsoft.public.sqlserver.programming)
  • Re: Dbase3 Conversion
    ... If you mean that it can sort easily through the interface, ... happens in the table design view. ... Primary Key, it makes an index to implement that. ... though I haven't seen dbase in so long that I ...
    (comp.databases.ms-access)
  • Re: junction tables for 3 many to many relationships
    ... aspects of design that I think are relevant. ... because the 4 fields could serve as a composite primary key. ... >> absolutely identifies a unique record. ... the ID's are aluminum bands placed on the legs of birds. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Key Violations in Append Queries
    ... Normally, if a primary key or other unique index is created, it is ... the design of the database requires uniqueness for the key involved. ... Whoever designed the database supposedly felt this was necessary. ... It may be that you should just omit this from the append query, ...
    (microsoft.public.access.queries)