I think I have found a limit to Access XP (2002), one the it NOT present in Access 97. I would like some confirmation on this.
I have found that if the total characters allowance for all fields in a table excede (and I am guessing here) 2048 bytes, then I can not perform an OLE SQL call.
So if I have table:
MyTAble
(
Field 1 length 10
Field 2 length 10
...
field X length YY
)
Then if the sum of the lengths of fields 1 ... X is greater then 2048, it will not work with OLE SQL command.
My program will operate fine on a system using access 97, but I receive errors on the system using XP.
Any Ideas as to what the actual limitation is?
I have found that if the total characters allowance for all fields in a table excede (and I am guessing here) 2048 bytes, then I can not perform an OLE SQL call.
So if I have table:
MyTAble
(
Field 1 length 10
Field 2 length 10
...
field X length YY
)
Then if the sum of the lengths of fields 1 ... X is greater then 2048, it will not work with OLE SQL command.
My program will operate fine on a system using access 97, but I receive errors on the system using XP.
Any Ideas as to what the actual limitation is?
