Results 1 to 3 of 3

Thread: primary key

  1. 07-28-2003, 03:33 PM #1
    shawnp
    shawnp is offline Registered User
    Join Date
    Jul 2003
    Location
    texas
    Posts
    1

    primary key

    I am currently working at an intership for a media company. They are running a small client server application using access 2000. The backend(tables) is on what somebody termed the server, and the frontend is(forms queries reports) is installed and linked to the 5 client computers on the hub.
    I am working on a project to normalize the database. When I look at the tables in the backend, The attribute that is the primary key has value 0. Yet when I look at the linked table the primary key attribute contains values. What gives???
    Reply With Quote Reply With Quote
  2. 07-28-2003, 10:39 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    So? whats your question my friend.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 07-29-2003, 07:52 AM #3
    KnooKie
    KnooKie is offline Registered User
    Join Date
    Jan 2003
    Location
    UK
    Posts
    277
    are you sure they are the same table ? Is the backend table definitely linked to the frontend ?

    Are there no records at all in the backend table ? But some in the frontend supposedly linked one ?

    If so it doesn't sound as though the backend tables are linked into the frontend properly.

    Have a look via the linked table manager and see if the tables are pointing to the right place ?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules