UtterAccess Discussion Forums > SQL Max Length in Access(max # of chars allowed in one sql satem

Full Version: SQL Max Length in Access(max # of chars allowed in one sql satem

UtterAccess Discussion Forums > Microsoft® Access > Access Queries

thirden

Nov 21 2008, 01:35 PM

Hey guys I was just wondering if anyone knows the maximum length a SQL statement can be in access if there is one.... IE 2000 characters.

thanks!

Edited by: thirden on Fri Nov 21 13:41:08 EST 2008.

DougY

Nov 21 2008, 01:54 PM

From Access Help:

QUOTE

Number of characters in an SQL statement approximately 64,000

Type specifications in Access Help... Plenty of good info...

thirden

Nov 21 2008, 01:55 PM

Thank you!

DougY

Nov 21 2008, 02:01 PM

You are welcome.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.