juddymar58
Programmer
Hi, I'm currently investigating moving one of our Access Databases to SQL Server. Originally I was looking using stored procedures to populate unbound forms as well as update the data when a save button is clicked. This sounds nice and clean however there are a couple of forms in the project which contain many subforms as well as alot of bound controls.
I was originally going to use the method these but have been considering running a parametrized query on an odbc linked table to return only one record at a time based on the users selection. Doing this will mean that I can still use a bound form, meaning there is far less work involved.
I'm concerned about the speed of the form, I have heard that jet will try to process the whole table even if the recordsource is filtered to return only one record. Is this true? The form is based on a table with about 600,000 records so I would like to keep things reasonably fast. I'm just wondering what peoples thoughts are on using this approach?
Thanks
Justin
I was originally going to use the method these but have been considering running a parametrized query on an odbc linked table to return only one record at a time based on the users selection. Doing this will mean that I can still use a bound form, meaning there is far less work involved.
I'm concerned about the speed of the form, I have heard that jet will try to process the whole table even if the recordsource is filtered to return only one record. Is this true? The form is based on a table with about 600,000 records so I would like to keep things reasonably fast. I'm just wondering what peoples thoughts are on using this approach?
Thanks
Justin