Microsoft Access - too many fields defined
843854Dec 15 2003 — edited Dec 16 2003I have studied up on this error message and I am still not sure why this is error is being thrown in my face.
Okay,
I understand that Access has a limit of handling 255 fields. What I don't unserstand is how is this limit being tracked? I am doing a lot of db transactions and unfortunately, the DB given to me can not be changed. I know that I have only started getting problems when I started using UPDATE sql statements to change the Database. When using flat INSERT Statements, I have no problems... I don't know what else to say, but I would like an elaborate account of why how Access is giving this "Too many fields defined" problem.
Takizzle