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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Query Maximum String Length, Any Version    
 
   
Peter Hibbs
post Apr 17 2012, 06:29 AM
Post #1

UtterAccess VIP
Posts: 734
From: Dorset. UK.
I am currently writing some VBA code which creates a query string in code and then copies it into the query for use on a form.

I seem to remember reading somewhere that there is a limit to the number of characters that can be used in a query string, somewhere about 2000 I think. Does anyone one have an exact figure for this?

TIA

Peter Hibbs.
Go to the top of the page
 
+
Bob G
post Apr 17 2012, 06:37 AM
Post #2

UtterAccess VIP
Posts: 8,104
From: CT
can you give an example of what you are building?
Go to the top of the page
 
+
jleach
post Apr 17 2012, 07:11 AM
Post #3

UtterAccess Editor
Posts: 6,709
From: Capital District, NY, USA
Hi Peter, check the wiki Access Limits. Looks like you're around the 64k range. There's a few other limits on queries there as well. IIRC this doesn't change except with V2010 64bit.

hth
Go to the top of the page
 
+
Peter Hibbs
post Apr 17 2012, 07:33 AM
Post #4

UtterAccess VIP
Posts: 734
From: Dorset. UK.
Jack,
Looks like I was misinformed, 64K will be plenty. Thanks.

Bob,
Hopefully the Wiki site has answered my questions.

Peter.
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: 18th May 2013 - 12:18 PM