Mega Code Archive

 

Categories / Delphi / ADO Database

 

Accessing ms access data with bcb

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).