gakiss2
Registered User.
- Local time
- Today, 05:12
- Joined
- Nov 21, 2018
- Messages
- 168
I am working on a database that can pull data from a SQL server. The avenue that I have available is to use Excel's data connection function. I then create a linked table in Access which is linked to the aforementioned Excel with the data connection. I made a combo on a form that pulls from that linked table. It works but it takes incredibly long to pull in the data. This is replacing a static table of essentially the same size with practically identical data and the combo attached to that static table (generic access table) has practically zero lag time. I can start typing in a partnumber and it completes it faster than I could type it in.
It seems obvious enough that the linked table is making the difference. I would like to understand why and is there anything that I can do to make it as fast or at least much faster than it is now. The point was to be able to connect to the data in the background and not have to frequently update the static table. Background is that this is manufacturing and the table represents part numbers and suppliers. They change often enough you don't want to go many days without an update.
Assuming there is no quick fix, the next step would be a way to automate importing a table from the same source.
Thanks in advance for the help.
It seems obvious enough that the linked table is making the difference. I would like to understand why and is there anything that I can do to make it as fast or at least much faster than it is now. The point was to be able to connect to the data in the background and not have to frequently update the static table. Background is that this is manufacturing and the table represents part numbers and suppliers. They change often enough you don't want to go many days without an update.
Assuming there is no quick fix, the next step would be a way to automate importing a table from the same source.
Thanks in advance for the help.