I have an MS ACCESS 97 database and I am trying to write to tables in it
using Borland C++Builder and ODBC. I can read but I can't add or change
the data in the tables. Has anyone been successful doing this with MS
Visual C++ ?
Jim [VC/MFC MVP]
To send mail, change nospam to msn
Visual C++ can do easy. You can use MFC defined objects for either ODBC or
MCSE, MCT, MVP
Remove NOSPAM from reply address
If you're going through ODBC you might need to make sure there's an unique
index on the table you're trying to write to...
ORCA Technologies, INC.
It sounds like you are using a non-updateable cursor. You will probably need
to use the cursor library when you open the database. Then, specify that you
want to use a static cursor when you open the recordset (this will give you
forward and backward scrolling as well as update capabilities). Since, you
are using Access, you may want to use the MFC DAO database classes rather
than the MFC ODBC database classes. The ODBC classes should work fine too
To reply to me via email please remove the _ from my email address.
Hi this is a thread from another news group that has not been
answered. Any ideas anyone?
Thank You, Thank You...you hit it right on the money. It seems SQL
import/export converted all my MS-Access memo fields to the SQL ntext
data type. Does SQL Server have a comparable memo field type? If not
how do people get around the memo field requirement? Create text field
large enough for the average requirement?
On Thu, 17 Jun 1999 16:40:30 +0400, Alexey Dolganov