Forum Moderators: phranque
I have an online app in Cold Fusion I'm working on where the query result is too large. I have about 6 INNER JOINS in one query and it gives me the following error.
[Microsoft][ODBC Microsoft Access Driver] Too many fields defined.
Is this a limitation of Access? It's not a big deal because I can break it up into several smaller queries, but I'm curious none the less. And if it is Access, is there another database format I can look to in the future if I have no way around it?
