Hi everyone,
I am trying to implement MajP's FAYT solution for a combobox, as discussed in the following post and MajP's provided solution "(MajP FAYT V12, class module: FindAsYouTypeCombo) (topic: "Search as you type with in Combobox / instant filter combobox itself" < cannot post the link)
I am using a linked table from an Azure SQL Server as the data source for the combobox. This linked table contains the following two coloms:
Table Structure:
-IngredientId: Primary key, initially set as an identity column. I removed the identity setting to avoid needing dbSeeChanges, which significantly slowed down performance.
-Ingredient: Originally set as varchar(1500), reduced to varchar(255) due to combobox character limits, even though some ingredients exceed this limit.-
-Number of Records: Approximately 20.000.
Unfortunately, I am encountering performance issues. The database frequently crashes, and the combobox response is slow. I suspect the issue may caused by the DAO connection but i am not sure.
Has anyone successfully implemented MajP's solution with large linked SQL Server tables (20.000+ records) in Access? Any tips on optimizing the DAO connection or general advice to improve performance would be greatly appreciated.
Thanks in advance for any insights!
I am trying to implement MajP's FAYT solution for a combobox, as discussed in the following post and MajP's provided solution "(MajP FAYT V12, class module: FindAsYouTypeCombo) (topic: "Search as you type with in Combobox / instant filter combobox itself" < cannot post the link)
I am using a linked table from an Azure SQL Server as the data source for the combobox. This linked table contains the following two coloms:
Table Structure:
-IngredientId: Primary key, initially set as an identity column. I removed the identity setting to avoid needing dbSeeChanges, which significantly slowed down performance.
-Ingredient: Originally set as varchar(1500), reduced to varchar(255) due to combobox character limits, even though some ingredients exceed this limit.-
-Number of Records: Approximately 20.000.
Unfortunately, I am encountering performance issues. The database frequently crashes, and the combobox response is slow. I suspect the issue may caused by the DAO connection but i am not sure.
Has anyone successfully implemented MajP's solution with large linked SQL Server tables (20.000+ records) in Access? Any tips on optimizing the DAO connection or general advice to improve performance would be greatly appreciated.
Thanks in advance for any insights!
Last edited:
