Error 3190 - Microsoft Access / VBA

Steve

An Access97 database I wrote contains a dynamic query whose results get exported
to Excel. I have WindowsXP and Access97, 2000 and XP installed. When I run the
query, it runs trouble free. A customer with Windows98 and Access97 on three
different machines runs the query on any of the three and gets error 3190 Too
Many Fields Defined. To run the dynamic query, fields for the query are picked
from multi-select listboxes. If one selected every field in all the listboxes,
there might be sixty fields. The customer gets this error no matter how many
fields he selects. Help says error 3190 occurs if the query contains more than
255 fields. Does anyone have any ideas what might be causing the error message
to appear?

Thanks!

Steve

Nov 12 '05 #1

Subscribe Reply

4737

Allen Browne

There has to be an error in the way Access is interpreting your dynamic SQL
statement.

Is there any chance that the user has spaces in his field names, and you
have not included square brackets around them? Any chance the code is
looping too many times? Trying to use criteria on a calculated field instead
of repeating the entire calculation in the WHERE clause?

It would be really instructive if you could Debug.Print the resultant SQL
statement when it fails: are you able to visit the client and do that, or
else send him a little test case that will log the failing query statement?

A97 was thoroughly tested in Win98, so I would be very surprised if that
combination were an issue. Is it possible he has other bad combinations? For
example, is he trying to use DAO 3.6 with A97 instead of DAO 3.51?

This answer feels pretty incomplete, but hopefully it is of some use. 60
fields is certainly not the problem, so the issue must be elsewhere.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve" <sp**@nospam.sp am> wrote in message
news:RB******** *********@newsr ead2.news.atl.e arthlink.net...

An Access97 database I wrote contains a dynamic query whose results get exported to Excel. I have WindowsXP and Access97, 2000 and XP installed. When I run the query, it runs trouble free. A customer with Windows98 and Access97 on three different machines runs the query on any of the three and gets error 3190 Too Many Fields Defined. To run the dynamic query, fields for the query are picked from multi-select listboxes. If one selected every field in all the listboxes, there might be sixty fields. The customer gets this error no matter how many fields he selects. Help says error 3190 occurs if the query contains more than 255 fields. Does anyone have any ideas what might be causing the error message to appear?

Nov 12 '05 #2

Steve

Allen,

Thanks for your reply!

We are both running the same frontend and backend files - works fine for me, he
gets error 3190. My conclusion from this is that the problem is external to the
database. We did check the references!

Steve
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:40******** **************@ freenews.iinet. net.au...

There has to be an error in the way Access is interpreting your dynamic SQL
statement.

Is there any chance that the user has spaces in his field names, and you
have not included square brackets around them? Any chance the code is
looping too many times? Trying to use criteria on a calculated field instead
of repeating the entire calculation in the WHERE clause?

It would be really instructive if you could Debug.Print the resultant SQL
statement when it fails: are you able to visit the client and do that, or
else send him a little test case that will log the failing query statement?

A97 was thoroughly tested in Win98, so I would be very surprised if that
combination were an issue. Is it possible he has other bad combinations? For
example, is he trying to use DAO 3.6 with A97 instead of DAO 3.51?

This answer feels pretty incomplete, but hopefully it is of some use. 60
fields is certainly not the problem, so the issue must be elsewhere.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve" <sp**@nospam.sp am> wrote in message
news:RB******** *********@newsr ead2.news.atl.e arthlink.net...
An Access97 database I wrote contains a dynamic query whose results get

exported
to Excel. I have WindowsXP and Access97, 2000 and XP installed. When I run

the
query, it runs trouble free. A customer with Windows98 and Access97 on

three
different machines runs the query on any of the three and gets error 3190

Too
Many Fields Defined. To run the dynamic query, fields for the query are

picked
from multi-select listboxes. If one selected every field in all the

listboxes,
there might be sixty fields. The customer gets this error no matter how

many
fields he selects. Help says error 3190 occurs if the query contains more

than
255 fields. Does anyone have any ideas what might be causing the error

message
to appear?

Nov 12 '05 #3

Similar topics

4382

Error in msvc in building inheritance.obj to build hello.pyd

by: AIM | last post by:

Error in msvc in building inheritance.obj to build hello.pyd Hello, I am trying to build the boost 1.31.0 sample extension hello.cpp. I can not compile the file inheritance.cpp because the two files containing some templates: adjacency_list.hpp and mem_fn.hpp can not compile. Does anyone have any solutions?

Python

16261

Error during deployment

by: Tony Wright | last post by:

Hi, I am having a problem installing an msi for a web site. The error message I am getting is: "The specified path 'http://mipdev05/features/Fas2' is unavailable. The Internet Information Server might not be running or the path exists and is redirected to another machine. Please check the status of this virtual directory in the Internet Services Manager."

.NET Framework

8417

ILINK32 Errors: Error: Unresolved external

by: Aravind | last post by:

we have two files: 1. rc4.c (defines one function "create_pin()") 2. MyImpl.c(calling the function "create_pin()"),This implements JNI method. 1.When I am trying to create .dll file with one file rc4.obj(rc4.c),it is creating the .dll file without any error. Command : ILINK32 rc4.obj 2.But,when we are trying to create .dll file with two .obj files with following errors.

C / C++

6413

how to resolve "error lnk 2001"

by: yanwan | last post by:

I met this problem in executing a c++ project in visual studio. Does anyone have suggestions to resolve "error lnk 2001"? --------------------Configuration: reconstruction - Win32 Debug-------------------- Linking... icarus_camera.obj : error LNK2001: unresolved external symbol _dgels_ icarus_leastsquares.obj : error LNK2001: unresolved external symbol _dgels_ icarus_maths.obj : error LNK2001: unresolved external symbol _dgels_...

C / C++

5718

Using namespace std and Error 19:

by: Enos Meroka | last post by:

Hallo, I am a student doing my project in the university.. I have been trying to compile the program using HP -UX aCC compiler, however I keep on getting the following errors. ================================================================= Error 19: "CORBAManagerMessages.h", line 4 # Unexpected 'std'. using std::string; ^^^

C / C++

6618

Error Handler best practices

by: deko | last post by:

I use this convention frequently: Exit_Here: Exit Sub HandleErr: Select Case Err.Number Case 3163 Resume Next Case 3376 Resume Next

Microsoft Access / VBA

5026

Error crystal websetup 9 install

by: p | last post by:

WE had a Crystal 8 WebApp using vs 2002 which we upgraded to VS2003. I also have Crystal 9 pro on my development machine. The web app runs fine on my dev machine but am having problems deploying. I created the websetup and built the MSI, have the bundled version. Copied to webserver and ran Websetup.msi. Said I had to remove old version, which I did, then reran WebSetup.msi and keeps giving me this error. "The installer was interrupted...

ASP.NET

19494

Custom Error Messages in Access

by: hyperpau | last post by:

Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge. I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...

Visual Basic 4 / 5 / 6

2897

Custom Error Messages

by: hyperpau | last post by:

Microsoft Access / VBA

9672

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10438

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10214

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10001

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7540

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6780

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5563

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3727

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2920

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General