There are several workarounds to this. The one I use...
I have a progress routine that exports the fields I need from the customer
table and creates an excel sheet of the data. My access db is linked to
that excel file. I have it set-up so it runs the export and updates the
excel file whenever my access file is opened, so it's always up to date
information. It runs in just a second and is seamless to the users. Our
customer list is very small so it's not an issue in terms of file space.
But, I know there are other workarounds that people are using - those might
be better for you depending on your needs.
I have a progress routine that exports the fields I need from the customer
table and creates an excel sheet of the data. My access db is linked to
that excel file. I have it set-up so it runs the export and updates the
excel file whenever my access file is opened, so it's always up to date
information. It runs in just a second and is seamless to the users. Our
customer list is very small so it's not an issue in terms of file space.
But, I know there are other workarounds that people are using - those might
be better for you depending on your needs.