Problem with Access 2.0 ODBC from VC++ MFC

Article View: comp.databases.ms-access

Article #5

Back to comp.databases.ms-access Previous Next

From: Curt Yardley
Date: Mon, 01 Apr 1996 14:11

22 lines
1055 bytes

Hi

I'm sure this problem has been previously addressed by this 
newsgroup but I've missed it.

I'm having a problem with MS Visual C++ 2.0 and MFC on NT 3.51 
(and 16bit 1.51 under 3.11 for that matter) and MS Access 2.0 
via ODBC. 

If a table has more than 40 fields, insertions work fine, but 
plain vanilla ODBC modfies or deletes fail with something like 
"Query to complex". Reduce the table (in DoFieldExchange) to 40 
or less fields, all works fine.

The exact same code for > 40 fields works fine with other 
databases, eg FoxPro.

Thanks,

Curt 

(fcorp@is.co.za)

Technical Details

Message-ID: <315FE405.733@is.co.za>

Path: arc1-ca.pugleaf.net!hermes.is.co.za!news

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!hermes.is.co.za!news
From: Curt Yardley <fcorp@is.co.za>
Newsgroups: comp.databases.ms-access,comp.lang.c++
Subject: Problem with Access 2.0 ODBC from VC++ MFC
Date: Mon, 01 Apr 1996 16:11:17 +0200
Organization: No organisation supplied
Message-ID: <315FE405.733@is.co.za>
NNTP-Posting-Host: t087.is.co.za
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 2.0GoldB1 (WinNT; I)