Re: Access 2000 Appending records to a table

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

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).

--
Joan Wild
Microsoft Access MVP
"geocoy" <geocoy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B1218148-0A49-4F97-A06C-0E1D5C75BD19@xxxxxxxxxxxxxxxx
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?




.

Relevant Pages