473,837 Members | 1,598 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Jet database engine cannot find......

I'm building a tracking system and I'm having some problems. I thought
this was relatively easy, but....

I have the following tables and fields (abbreviated):
tblPermitMain
PermitID - pk
ApplicantID (from tblApplicant)
PropertyID (from tblProperty)
PermitNumber
PermitApprovalD ate
PermitResidenti al
PermitCommercia l

tblApplicant
ApplicantID - pk
ApplicantFname
ApplicantLname
ApplicantCity
ApplicantState

tblProperty
PropertyID - pk
ParcelNumber
PropertyAddress

The tables above are related by the ID fiels with one to many
relationships. I use a query which includes all of the fields above
and have made a form based on this query.

When I create a new record in the form and I only input information
contained in PermitMain table and the Applicant table, I recieve an
error message when I close the form, or create a new record. The error
message is

"The microsoft Jet database engine cannot find a record in the table
tblProperty with key matching field(s) tblPermitMain.p ropertyID."

Hopefully this is just a minor glitch in my table setup
(relationships? ). Any help on this would be appreciated.

I'm an obvious newbie to access so please excuse the ignorance.

Thanks!!

Nov 13 '05 #1
2 4977

ds***********@g mail.com wrote:
I'm building a tracking system and I'm having some problems. I thought this was relatively easy, but....

I have the following tables and fields (abbreviated):
tblPermitMain
PermitID - pk
ApplicantID (from tblApplicant)
PropertyID (from tblProperty)
PermitNumber
PermitApprovalD ate
PermitResidenti al
PermitCommercia l

tblApplicant
ApplicantID - pk
ApplicantFname
ApplicantLname
ApplicantCity
ApplicantState

tblProperty
PropertyID - pk
ParcelNumber
PropertyAddress

The tables above are related by the ID fiels with one to many
relationships. I use a query which includes all of the fields above
and have made a form based on this query.

When I create a new record in the form and I only input information
contained in PermitMain table and the Applicant table, I recieve an
error message when I close the form, or create a new record. The error message is

"The microsoft Jet database engine cannot find a record in the table
tblProperty with key matching field(s) tblPermitMain.p ropertyID."

Hopefully this is just a minor glitch in my table setup
(relationships? ). Any help on this would be appreciated.

I'm an obvious newbie to access so please excuse the ignorance.

Thanks!!


If you're entering data into the PermitMain Table, then the data you
want to enter for applicant and property must already exist before you
can enter data for that. That's what the message means. JET is trying
to enforce referential integrity (which says there must be a record in
one of your tables with the same value in the Primary key field as
there is in the join field in that table....) Oh, the joys of set
math. You may need to force a save of your main table record first.
then you can add children to it.

Nov 13 '05 #2
On 26 Mar 2005 21:12:27 -0800, ds***********@g mail.com wrote:

Access has a cool feature that was specifically designed to enter 1:M
information: the form/subform combination.
Take a look at the Northwind sample application, the Order form.
Observe master information on the main form, and detail information in
the subform.
At runtime, the user enters data in the main form first, and when he
sets focus to the subform that information is automatically saved. The
PK information is available, and entered in a (typically hidden) field
in the subform (as given by subform.linkmas terfields and
subform.linkchi ldfields).
Study this design pattern, and you will find MANY uses for it.

-Tom.
I'm building a tracking system and I'm having some problems. I thought
this was relatively easy, but....

I have the following tables and fields (abbreviated):
tblPermitMai n
PermitID - pk
ApplicantID (from tblApplicant)
PropertyID (from tblProperty)
PermitNumber
PermitApproval Date
PermitResident ial
PermitCommerci al

tblApplicant
ApplicantID - pk
ApplicantFna me
ApplicantLna me
ApplicantCit y
ApplicantSta te

tblProperty
PropertyID - pk
ParcelNumber
PropertyAddres s

The tables above are related by the ID fiels with one to many
relationship s. I use a query which includes all of the fields above
and have made a form based on this query.

When I create a new record in the form and I only input information
contained in PermitMain table and the Applicant table, I recieve an
error message when I close the form, or create a new record. The error
message is

"The microsoft Jet database engine cannot find a record in the table
tblProperty with key matching field(s) tblPermitMain.p ropertyID."

Hopefully this is just a minor glitch in my table setup
(relationships ?). Any help on this would be appreciated.

I'm an obvious newbie to access so please excuse the ignorance.

Thanks!!


Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
4421
by: Dejan M. | last post by:
Please can you help me with this problem: In the next form, when I Add new person who is not registered in the base I had the massage: The Microsoft Jet database engine cannot find a record in the table 'CLAN' with key matching field(s) JMBG. The question is: How to add data for the unregistered visitors in the next fields: JMBG (unique person number);(translation) STATUS;
17
14546
by: MLH | last post by:
The Microsoft Jt database engine can not find tblJobSites, error #3078. That's what I get when executing this code... Private Sub Command1_Click() Dim MyWorkspace As Workspace Set MyWorkspace = DBEngine.Workspaces(0) Dim MyDB As Database Dim MyQueryDef As QueryDef, MyRecSet As Recordset Dim MyPeriod As String, MyRand As Double
3
7906
by: Russell Read [MSFT] | last post by:
Hi all, I am using VB script in ASP to access a MS Access database. This works fine until I want to access the same db placed on a file share. The code I am using is... 'create connection object Set db = Server.CreateObject("ADODB.Connection") 'specify the database provider
3
2029
by: COHENMARVIN | last post by:
I put the following code in my asp.net page: dbPath = MapPath("/FBDB/db1_newport2003.mdb") strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" strConnect = strConnect & "Data Source=" & dbpath & ";" objConnect = new OleDbConnection(strConnect) ============================= but I get the following error: <b>* Error while updating original data</b>.<br
2
2124
by: Enska | last post by:
I have problems connecting my access database I get information .. I cant use my database and I'm administrator on my computer so permission shutnot bee problem, but I dont know Where is the problem. Can enybody help me!!!! Server Error in '/Koulu/tietokannat' Application. -------------------------------------------------------------------------------- The Microsoft Jet database engine cannot open the file...
5
2270
by: samadams_2006 | last post by:
I'm having a problem in accessing a Microsoft Access Database in a VB.NET Web Application. It's so straight forward, I thought I'd walk you through all the details here: 1) I have a .NET Web Application called "Lesson18b" under "C:\Inetpub\wwwroot\Lesson18b". 2) I have one Web Form on this Lesson called "Form18b.aspx" 3) In this same Folder under Inetpub I have the Microsoft NorthWinds
1
7861
by: jesmi | last post by:
my code is: U]employee.cfm <html> <head> <title>Employee List</title> </head> <body> <h1>Employee List</h1>
1
8331
by: babyjek | last post by:
SELECT ProjectID, ProjectName, ProjectDescription, SequenceNumber, LastUpdateDate FROM Project WHERE ProjectID = @ProjectID; (The Microsoft Jet database engine cannot find the input table or query 'Project'. Make sure it exists and that its name is spelled correctly.)
6
3678
by: warpcon | last post by:
Im trying to build a database starting with one of the templates that come with access. I took out the employee part in all the tables and forms. Now when I pull up a workorder and then try to view the report on it it gives me the message " Ms jet database engine cannot find the input table or query ' Employees'. Make sure it exists and that its name is spelled correctly. I deleted the employee parts on purpose because I didnt need it. Where...
0
9830
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9682
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10864
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10263
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9390
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7803
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6989
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5664
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5842
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.