Query size limitation

  • Thread starter Thread starter Guest
  • Start date Start date
Is this a homework question?

Have you tried something and had it fail? Was there an error message?

Have you checked Access HELP for "specifications"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Yes there are limitations.

255 columns max
2000 bytes per record (row) (except for memo fields)

Check out Specifications in the Help.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 
Thanks John

John Spencer said:
Yes there are limitations.

255 columns max
2000 bytes per record (row) (except for memo fields)

Check out Specifications in the Help.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
Click to expand...
 
Hmmm, I didn't think I was lecturing. I'm pretty sure I was asking for more
information so I could understand the context so the answer I offered was
appropriate to your situation.

One way you could avoid getting responses like mine (or reduce the chance)
in the future might be to simply post "I don't want to know how to find out
for myself, just tell me the answer..." <g!>

In case you weren't aware of it, most of the folks who answer here are
volunteers. Do you think your response is likely to encourage volunteers to
respond to your future questions?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top