harleyskater
IT Manager
- Local time
- Today, 10:21
- Joined
- Oct 29, 2007
- Messages
- 95
Form with a large amount of records-Date entries are slow
I have an Access 2007 accdb file. The problem is I have one form which is used a lot. In access 2003 as a mdb file there was no problem, but we upgraded last week and now all the dates on this particular form, if changed, there is a giant pause for about 20 seconds. Anyone else having this problem? or know a possible cause? I have the form set up as a dynaset and the recordset is coming directly from the main table.
Thank you : )
I have an Access 2007 accdb file. The problem is I have one form which is used a lot. In access 2003 as a mdb file there was no problem, but we upgraded last week and now all the dates on this particular form, if changed, there is a giant pause for about 20 seconds. Anyone else having this problem? or know a possible cause? I have the form set up as a dynaset and the recordset is coming directly from the main table.
Thank you : )
