The only time this might happen is if your table isn't normalized and you
have too many fields. Typically, a normalized table will rarely have more
than 30 fields. I've seen a few with more, but very rarely. Access allows as
many as 255 fields in a table, but I've never seen one anywhere near that
size.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads http://www.datastrat.com http://www.mvps.org/access
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.