another way aside from ODBC

[AccessKid]

I have a form that needs to have an SQL table as its recordsource. Is there a better way to connect the form to the table without using ODBC? I have tried the ODBC approach but it seems that the form's data manipulation response time is too slow. Or it is just wishful thinking on my part to assume that ADO or another method of doing this will speed up the response time a little bit?

Thanks.

 

[Pat Hartman]

You should not use an ODBC table as the recordsource for a form. This forces Access to retrieve EVERY row from the linked table. You should use a query with a Where clause so that the recordset for the form is preferably only a single row.

 

[AccessKid]

Hi Pat:

Thanks.

This means I have to modify my form to allow a search before any record is displayed. I'm not sure if I saw this in Access before but is it possible to display the form without any record being displayed until a search is made by the user?

Second question: will those forms with combo boxes that get their item data from an ODBC table also not advisable? What are my choices for those combo's?

 

[Pat Hartman]

1. Once you have built the form, you can remove the query from the recordsource and replace it via code once you have prompted for a value to use in the where clause.

2. Depends on the number of records that the combo needs to display. If it could be thousands, you might want to pre-select by having the user enter a couple of characters and then using that info to populate the rowsource of a second combo from which they can select the actual data that they want.

 

[AccessKid]

Thanks for the tips, Pat.