Most of these issues relate to performance or updatability.
Developers often migrate data to SQL Server expecting an improvement in application performance.
Although performance does often improve, there are many cases where it remains the same or even degrades.
In some cases, performance of certain queries degrades to an unacceptable level.
The interaction of these two engines can sometimes yield results that are inferior to those obtained by using only the Jet database engine with native Office Access tables.
This white paper discusses several of these issues and presents strategies for resolving them.
This occurs because sometimes the Office Access database engine determines that it cannot submit an entire query to SQL Server.
Select a template that shows TSQL to see all the statements being processed by the server.
I link to the CSV file with no issue...however, when I chage the imported table to the linked CSV so I can use that value to update my Acccess table I receive an error message That "Updating a linked table is not supported by ISAM"...