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





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

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