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

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

From: GenMcD (GenMcD_at_discussions.microsoft.com)
Date: 02/18/05 

Date: Fri, 18 Feb 2005 14:29:03 -0800

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.

Relevant Pages

  • Slow to open form in design view
    ... I have a form in my database that has a good deal going on with it. ... Its built on a simple query but has a few sub forms on it. ...
    (microsoft.public.access.forms)
  • Form Problem
    ... I recently built a database and have created a form for data ... review/entry pulling from a query. ...
    (comp.databases.ms-access)
  • Re: Help! Have I lost my query?
    ... affects only any new database you create. ... Some query names are "reserved" and will be ... but the one I built yesterday isn't. ... it says "Access 2000 File Format." ...
    (microsoft.public.access.queries)
  • simple query no data found
    ... built a database where table 1 fields take their data from a second table ... query to find a name i get nothing. ... word searches and single letter searches tried all these. ...
    (microsoft.public.access.queries)
  • Re: Transferspreadsheet Access 2003 and 2007
    ... As you are doing a query on a query, could the underlying query be the ... I have a database I created in access 2003. ... data into what the business area needs to see. ...
    (microsoft.public.access.queries)