PC Review

Thread Tools Rate Thread

Re: Error 3190, Too Many Fields Defined

Posts: n/a
      14th Sep 2004
Hi Larry,

try to download newest MDAC (2.8) on


and/or latest service pack for the MSJET 4.0 Database Engine:


IF there is any "anomaly" in Jet database engine, it should repair it.

I assume reinstalling of Windows/Office XP might be unuseful. Do it if any
others steps/ideas/hints does not work.

Anyway, reduce the field count, if it is possible. Always try to handle with
less fields as possible.

Pavel K.

"LarryP" <(E-Mail Removed)> wrote
news:(E-Mail Removed)...
> Access XP/Windows 2000.
> I have two split databases, almost identical interface and features but
> different linked Excel source files -- let's call them DB A and DB B.

> has a "Graph It" feature which, when clicked, exports the output of a

> to an Excel file and generates a simple line graph. These two databases

> used by 90+ people.
> ONE of those users of DB A has started getting Error 3190, "Too many

> defined," when she runs the "Graph It" feature. Nobody else, as far as I
> know, is getting this error, and it runs fine on my computer. I ran a

> procedure to check the field count for each table in the back end file,

> none of them is anywhere close to the maximum. I've run repair and

> on the front end and back end files, and have reinstalled Access on the
> user's computer just to be on the safe side, but no luck.
> Does anyone have any idea why this one user is encountering this when

> else is, and what I might do about it? The line of code that generates

> error is as follows; it works fine for me, for all the other users of DB

> and for all the users of DB B INCLUDING the one who's started having this
> problem with DB A.
> DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
> "qryGraphInfo", "c:\IPTGraph.xls", True

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there any way to correct a "too many fields defined" error? =?Utf-8?B?U2lzdGVyU2NyaWJl?= Microsoft Access Forms 3 23rd Mar 2005 12:19 AM
"Too many fields defined" error message Godzilla Microsoft Excel Misc 1 7th Jun 2004 01:57 AM
Access 2K Error: too many fields defined. Microsoft Access 3 24th Apr 2004 10:35 AM
Error message: "Too many fields defined" =?Utf-8?B?TGlvbnRvdGVt?= Microsoft Access 2 23rd Apr 2004 07:14 AM
Re: Too many fields defined Error John Vinson Microsoft Access Queries 0 8th Jul 2003 07:41 PM




All times are GMT +1. The time now is 05:22 AM.