UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> SQL Max Length in Access(max # of chars allowed in one sql satem    
 
   
thirden
post Nov 21 2008, 01:35 PM
Post #1

UtterAccess Enthusiast
Posts: 95
From: TX
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.
Go to the top of the page
 
+
DougY
post Nov 21 2008, 01:54 PM
Post #2

Utterly Abby-Normal
Posts: 9,757
From: Seattle, WA [USA]
From Access Help:

QUOTE
Number of characters in an SQL statement approximately 64,000


Type specifications in Access Help... Plenty of good info...
Go to the top of the page
 
+
thirden
post Nov 21 2008, 01:55 PM
Post #3

UtterAccess Enthusiast
Posts: 95
From: TX
Thank you!
Go to the top of the page
 
+
DougY
post Nov 21 2008, 02:01 PM
Post #4

Utterly Abby-Normal
Posts: 9,757
From: Seattle, WA [USA]
You are welcome.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 02:49 PM