Why won't my query save more than 475 records?

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

Guest

I am using ACCESS 2002. In my database I have built in a form for my users to
enter data easily. Two tables are automatically populated from this query
upon enty of data into the form. After saving 475 records to the underlying
query they are no longer able to enter any more without losing the records. I
entered 10 additional records which appeared to have been saved, however
after exiting the form and checking the underlying query they are not there.
One of the tables though, is populated from the additional records that were
entered into the form.
 
I don't have a very clear picture of what you described...

You have a form.

Data entered into the form is (?somehow?) distributed to two tables ... and
you said "automatically". How does that work? Access provides a built in
mechanism to connect a form to a single table, but two?!

You mention "losing records" after 475 have been entered, but you said "to
the underlying query". You can't add records to queries in Access -- you
add records to tables.

You mention adding 10 records and exiting the form and checking the
underlying query. Is that the query that you use to populate the form?
What about the underlying tables? You said that one of the tables gets the
new records -- does this mean the other one doesn't?
 
Jeff, Thank you for responding...I will attempt to make this clearer...I
built a query based on two tables. Then I created a form and used the query
as my record source. When data is entered into my form it populates the query
and both tables associated with the query. Over 475 records have been entered
via the form but when record 476 and beyond are entered they are not being
saved in the form or the query and only in one of the tables.

I hope that I'm saying this right; if not please do ask me more questions. I
can't find anyone who can assist me with this.

I really appreciate your assistance.
GenMcD
 
Back
Top