Access 2000 Appending records to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using an append query to add records to a linked table in another Access
2000 database. The nature of the information stored on the originating table
is such that all fields can not be populated at the instance it is created.
So I would like to append the record with the data that is available at the
time, leaving some fields blank. When I try to run the append quwery, it
fails to append the record to the linked table. If I add bogus data to the
fields just to populate the blanks, the query works. Is there some way
around this process of adding bogus data just to poplate the fields so the
append query works?
 
It would appear that those fields have their 'required' property set to Yes.
You need to consider why it is set to yes, and whether the property can be
set to no, or only do the append when you have full information.

This property would be set in the backend mdb where the table is located
(not on the link in the frontend).
 
Dummy me, I should have told you I already checked for "Required"
In the past I have solved this problem in two ways, either by adding bogus
data or by adding an "IF" statement to the query in the empty field and tell
it to add text if the field is null
 
You need to figure out why the query is failing, if the fields are not set
to required. When you say 'it fails to append', what happens? What is the
error message, if there is one? There could be other reasons for it to
fail - like referential integrity, duplicate keys, validation rules, etc.
 
Back
Top