Limit of 255 characters of connections string

[spence27]

i have been seting up a front end to work of access using ado and i have hit a brick wall. My font end builds a SQL string using the limits and grouping useres select. Once this SQl string is pulled together i send it against the db for the results.

In simple testing everything was fine however once i doing some realistic testing things stopped working, and it looks to be down to the length of the query 600 characters or more.

Is there a way to pass a long sql string to access via ADO ?

Can anyone think of a way around this other than stored procedures (way to many options to predict each and every one)

I really would appreciate any help on this

 

[Remou]

Try posting the SQL in Microsoft: Access Queries and JET SQL Forum: forum701. It is very possible that someone there will come up with a slimmer version.

 

[spence27]

Thanks i have re-posted to the given forum and clsoed this thread