SQL table Access combo box

[Guest]

Hi all,
What would be the best way to populate combo box from SQL to Access. There
are over 800,000 records in the SQL db (street addresses). AS you can
imagine, just creating a combo box from an ODBC connected SQL table is a bit
sluggish. If you can think of a way in Access (2k,XP) that would be best.
But if you think the best answer is on the SQL side that will work as well.
Thanks,
Nick

 

[Jeff L]

Have you tried running a pass through query?

 

[OfficeDev18 via AccessMonster.com]

Nick,

In my experience, ODBC connections from within Excel are faster than Access,
and more reliable. What I do is to use Microsoft Query from within Excel to
make the ODBC connection, and save the Excel workbook (*.xls). In Access,
link (NOT import; that way the data is dynamic and doesn't need refreshing)
to the Excel workbook.

Hope this helps,

Sam

 

[Guest]

Thank you, I will let you know after the holiday weekend
Nick

 

[John Nurick]

Hi Nick,

Allen Browne has sample code for handling comboboxes with large numbers
of records in the rowsource: you'll find it somewhere at
www.allenbrowne.com.)