Question:
I have had no success getting at Microsoft Access data using
BCB other than a simple TTable view. Using TQuery I can get
a read-only view to work, but I cannot a read/write view to work.
After the login screen I am presented with an exception message
like 'Passthrough SQL connection must be shared'.
Answer:
Use the Database Engine Configuration to change the 'SQLPASSTHRU
MODE' option in the alias associated with your Access database
from its default blank value to 'SHARED AUTOCOMMIT' (without
the quotes).