Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2014

    Red face Unanswered: 'The Microsoft Access database engine cannot find a record in the table

    I am incurring a message saying 'The Microsoft Access database engine cannot find a record in the table "Process Prices' with key matching field(s) 'Process'.

    There is Quote table which has a field 'process' that is linked to Process Name ID in a table 'Process Name'. Within this table there are 10 fields (process 1, process 2... process 10). Each of these fields is linked to Process ID in the Process Price table which contains the Process, set up cost and price per unit.

    The Quote FORM has process 1, process 2...process 10 and on this form I am incurring the above message. I understand that the topic area I am looking at is normalisation but I am not sure how to change my database so that it works.


  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    without seeing the table design and or the query design there is precious little we can do to help

    however whenevr I see a table wilt columns names Process1,Process2....processX I tend to fear the worst

    the error message is saying it cannot find a column called process in table Process Prices, not process 1, process 2 or whatever

    that woudl be the first point of call

    using spaces in tabel and column names is a recipie for disaster. if you need the sapcdes to make the column names more human friendly then set the caption property for the column in the table design. otherwise use CamelCase or underscores. EG:-

    I'd rather be riding on the Tiger 800 or the Norton

Tags for this 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