I don't know if this is a Form or Query question, maybe neither?
a) My database had 7,000 records.
b) Performance was acceptable when I used a form to review/edit records. The form source is a Query.
c) I added 80,000 records.
e) The performance dramactically decreased. It now takes 4 seconds on the form when I go to the next record.
f) This will be a multi-user database on the server.
I created a "Make-Table" Query that creates a smaller record size table and this improved performance. This works fine for my desktop, but I'm guessing when it's on the server it won't be effective with users creating a new table at the same time.
What is the best way to bring filtered data into a form?
I'm still a Rookie...Thanks!
a) My database had 7,000 records.
b) Performance was acceptable when I used a form to review/edit records. The form source is a Query.
c) I added 80,000 records.
e) The performance dramactically decreased. It now takes 4 seconds on the form when I go to the next record.
f) This will be a multi-user database on the server.
I created a "Make-Table" Query that creates a smaller record size table and this improved performance. This works fine for my desktop, but I'm guessing when it's on the server it won't be effective with users creating a new table at the same time.
What is the best way to bring filtered data into a form?
I'm still a Rookie...Thanks!
