Limit of 255 fields in Jet 2.5 
Author Message
 Limit of 255 fields in Jet 2.5

Hello Wulfie

I would suggest restructuring what you are doing if possible.  255 fields
is a bit much for a single recordset.

--
Ibrahim Malluf
a MS Dev. MVP
_____________________
Malluf Consulting Services

=====================
Read about my horror story
with Compuweb.com
http://www.*-*-*.com/


Quote:
> I just had a message 3190, after I wrote a recordset with more than
> 255 fields.  Is there any way around this?



Tue, 09 Nov 1999 03:00:00 GMT  
 Limit of 255 fields in Jet 2.5

->I just had a message 3190, after I wrote a recordset with more than
->255 fields.  Is there any way around this?

No, that is the limit. I would break your recordset up into smaller
related chunks.

Paul
~~~~



Tue, 09 Nov 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Info on 255 field limit

2. 255 char limit for a field

3. Text driver other than Jet's (need over 255 fields)

4. Problem with Memo field in Jet 2.5 Parameter Query

5. Error setting field to Null with Jet 4 (SP5) and ADO 2.5

6. Winsock INET_ADDR returns INADDR_NONE for 255.255.255.255

7. Jet 2.5 Vs. Jet 3.0

8. Jet 1.1 to Jet 2.0 or 2.5

9. Displaying MS Access fields over 255 characters (Memo fields)

10. 255 limit in SQL in code

11. 255 SQL character limit

12. 255 character limit on SQL statements

 

 
Powered by phpBB® Forum Software