I have an access database as a front-end to a MS SQL server.
On a form, I have a bound grid that selects a bunch of fields from a table.
When I have relatively few records in the table, I see no issue.
I just loaded 65000 records, and now the form takes about 2 minutes to actually open.
When I use shift-click and run the form manually, it loads almost instantaneously.
I am assuming somehow the debugging mode is maybe late-binding my data?
How can I get this functionality from the 'double click' which my users will be doing instead of the 'shift-click' I use for debugging?
Hoping someone can shed some light on this, and if there is some other solution, i would be most open to hearing it!
Thank you,
Jerry