Re: Secret to getting a response?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"John Spencer" <spencer@xxxxxxxxx> wrote in message
news:OnB0efODHHA.4144@xxxxxxxxxxxxxxxxxxxxxxx
Well, now at least I know why I had no idea about the failure. I've always
been able to ensure that there was a Primary key in the tables. Hopefully, I
can keep this in the back of mind somewhere - so if it happens to me, I will
have a clue.

Yeah, you get used to seeing this when you have to connect to a lot of legacy
"tables". They often are not only not properly structured "relationally", but
there is no way practical to make them so that they are. You just do the best
you can with the junk you have to work with :-)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Relationship Question:
    ... I want to have same primary key for all the records... ... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
    (comp.databases.ms-access)
  • Re: Problem with Primary Key
    ... Null is not allowed in a Primary Key field. ... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
    (microsoft.public.access.gettingstarted)
  • Re: Can a DataTable have foreign keys?
    ... as "myfield = 14". ... Keep in mind that every select you run, it will be faster the second time - ... > able to search in a specific column besides the Primary Key column?? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Date Serial problem
    ... RBrandt at Hunter dot com ... JobNumber to be primary key in table as it matches what I had before ... JobNumber is in query as expression JobNumber: ... expression then you do not need a "saved field" containing the same data. ...
    (comp.databases.ms-access)
  • Re: update/append from table "b"to Table "a"
    ... what I had in mind and do not know how to do yet is as follows: ... >You need to tell us what is the "primary key" of each table. ... >HTH, ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)