Table Stability

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

Guest

Hi All

Is there are certain amount of records that can be placed and stored in a
table before it starts behaving strange. I have approximately 1000 records
in a table. I find that whenever the user adds a new record to the table and
they go to print the report to reflect the updated information. No
information is generated to show the current information.

Does anyone have any ideas why this would be?

And what I can do to resolve the issue.

Thanks
 
Are you trying to print before saving the record?

1000 records is not big at all. How many fields does your table have and
what data types? If you are storing pictures or other data in your table,
you could run into trouble.

If you have 20 or 30 fields per record and they are just normal data types,
1000 records is NOTHING to Access.
 
the table only has 3 fields.

Data type - all text. No pictures is being stored in the table.

Any idea why the report would not be displaying the new data added to the
table. No printing is occuring after the record is saved.
 
You say that the report is not displaying the new data added to the table,
then you say that no printing is occurring after the record is saved. I'm
confused. You should be saving the record, then running the report. Your
report should then show everything in the table at that time (including the
record you just saved). If you are trying to print before you have
completed the save, then that unsaved record will not show on the report.
Did I misunderstand?
 
You had asked if i am trying to print before saving the record, and I was
indicating no I am not. Printing is occuring after the record has been added
to the database.

So the data is been added to the table. The information is therefore saved
to the table. The report is run however the data that was just added to the
table is not being reflected in the report.
 
The only way I can imagine that happening is if your report (or the
underlying query) is filtering the records somehow to exclude any records
added after a certain time.
 
Is the report based on the table, or on a query? If on a query, is there
anything in the query that would be restricting what's returned?
 
Back
Top