Question and Answer Database FAQ1909C.txt Accessing MS Access data with BCB Category :Database Issues Platform :All Product :C++Builder 1.x 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). 7/2/98 10:32:32 AM
Last Modified: 01-SEP-99