Главная страница | назад

Article #16909: Accessing MS Access data with BCB

 Question and Answer Database

FAQ1909C.txt   Accessing MS Access data with BCB
Category   :Database Issues
Platform    :All
Product    :C++Builder  1.x

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

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