Info on 255 field limit 
Author Message
 Info on 255 field limit

David,
The column/field quantity limit will likely depend on the database you are
using. If 255 is not enough, I would take a look at the "normalization"
rules and see if you could redesign your table to reduce the number of
columns. I have never built or seen a table with more than roughly 50
columns. Any good database book and probably the documentation will have
information on normalization. Hope this helps.

Oscar Bowyer

Quote:

>Hello,

>I've written an import/export program using the data control. When I try to
>import/export to a file with more than 255 fields to a table I get an
error.
>Is 255 a built-in limit for a table? I don't want to be chasing phantoms.
If
>it's not a built in limit, can anyone point me in the right direction to
>solve my problem?

>Thank you.

>David Walonick




Sat, 03 Nov 2001 03:00:00 GMT  
 Info on 255 field limit
Hello,

I've written an import/export program using the data control. When I try to
import/export to a file with more than 255 fields to a table I get an error.
Is 255 a built-in limit for a table? I don't want to be chasing phantoms. If
it's not a built in limit, can anyone point me in the right direction to
solve my problem?

Thank you.

David Walonick



Sat, 03 Nov 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Limit of 255 fields in Jet 2.5

2. 255 char limit for a field

3. Winsock INET_ADDR returns INADDR_NONE for 255.255.255.255

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

5. 255 limit in SQL in code

6. 255 SQL character limit

7. 255 character limit on SQL statements

8. 255 char limit with FormField from VBA?

9. RecordSource 255 char limit workaround?

10. TabStrip has a 255 limit ?!?

11. VB5: 255 limit on forms

12. Access 255 record limit, instrumentation database?

 

 
Powered by phpBB® Forum Software