| Accessing MS Access data with BCB |
|
|
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).
|
| Hits/month | 2,500,000+ |
| Downloads (Since May 2000) |
7,393,709 |
| Total Files | 6,023 |
| Forum msgs | 7,670 |
| Articles/FAQs | 70+/900+ |
| Kylix |
| Tips n Tricks |
| FAQs |
| Knowledge Base |
| Bug Listings |
| Articles |
| Books |
| Newsgroups |
| Links |
| Submissions |
| Testimonials |
| Advertising |
| Contact Us |
| About Us |
Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use