472,126 Members | 1,402 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,126 software developers and data experts.

Subscript out of range during execution Select statement

I am getting a Subscript out of range after executing the following command
Set oRstPick = connTemp.Execute(sSQL)

It is a simple query:
sSQL = "SELECT idCategory, categoryDesc, idParentCategory FROM categories WHERE idCategory <> 1;"

My connection string looks like this:

connString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &server.MapPath("../database/comersus.mdb")&";"
set connTemp=server.createobject("adodb.connection")
connTemp.Open connString

I am allocating like this:
Dim sSendBack, sSQL, sCurItem, connString
Dim oRstPick, oCats, connTemp, sValueName

It works as long as the number of rows in the Access database is less than 112 rows. When I have 112 rows or more I get the 'Subscript out of range'

Any ideas?


Sep 18 '06 #1
0 2057

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

51 posts views Thread by Pedro Graca | last post: by
reply views Thread by ssims | last post: by
6 posts views Thread by josh | last post: by
6 posts views Thread by Andy | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.