Createobject of '(null)' caused exception C0000005

[wk6pack]

Hi,

I'm getting this error on my asp page intermittently. One day it is fine,
another day, it crashes a lot. I have searched the web and microsoft on
this and they say it is a recordset assigned to a session variable.

I dont assign any record sets to session variables in my code. I assign
values to the session variables though.
The place it seems to crash is Set AccessConn =
Server.CreateOb ject("ADODB.Con nection")

code:

connstr = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" &
Server.mapPath( "EmployeeTransa ctions.mdb")
Set AccessConn = Server.CreateOb ject("ADODB.Con nection")
AccessConn.open connstr

'get session("loc") to see if they are allowed to update records
lloc = session("sploct ype")
loccode = session("sploca tiondesc")

'Determining the ability to access update records
if lloc = "School" then
accessupdate = 0
else
accessupdate = 1
end if

Set rs = Server.CreateOb ject("ADODB.Rec ordset")
sql = "select emprecid, employeeno, employeelastnam e, employeefirstna me,
iif(isnull(hrst atus),'&nbsp',h rstatus) as hrstatus,
iif(isnull(hrda te),'&nbsp',hrd ate) as hrdate,
iif(isnull(budg etstatus),'&nbs p',budgetstatus ) as budgetstatus,
iif(isnull(budg etdate),'&nbsp' ,budgetdate) as budgetdate," & _
" iif(isnull(payr ollstatus),'&nb sp',payrollstat us) as payrollstatus,
iif(isnull(payr olldate),'&nbsp ',payrolldate) as payrolldate,
iif(isnull(bene fitdate),'&nbsp ',benefitdate) as benefitdate,
iif(isnull(crea tedby),'&nbsp', createdby) as createdby,
iif(isnull(proc essstatus),'&nb sp',processstat us) as processstatus,
employeetype, location from employeetransac tion "

'we only display the records for the school location otherwise, we display
all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTrans action.PayrollD ate >=(date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTrans action.PayrollD ate >= (date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<>FALSE)) order by emprecid desc
"
end if
set rs = AccessConn.exec ute(sql)

Any ideas??
thanks,
Will

[Aaron [SQL Server MVP]]

Several suggestions.

(a) don't use Server.CreateOb ject, just CreateObject

(b) what is set rs = Server.CreateOb ject("ADODB.Rec ordset") for? You
override it later with set rs = AccessConn.exec ute(sql) ... I also changed
"AccessConn " to a more standard "Conn"...

(c) don't do presentation things (replace null with "&nbsp;") in the query.
Do that where it belongs, in the presentation tier! Wherever you have a
value coming back from the resultset that needs to be at least "&nbsp;", use
the function I wrote below called sb (showblanks). Or, just response.write
rs("column") & "&nbsp;" ... it makes your query much easier to read, doesn't
it?

(d) make sure you close and destroy both the recordset object and the
connection object after you're done.
connstr = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" &
Server.mapPath( "EmployeeTransa ctions.mdb")
Set Conn = CreateObject("A DODB.Connection ")
Conn.open connstr

'get session("loc") to see if they are allowed to update records
lloc = session("sploct ype")
loccode = session("sploca tiondesc")

'Determining the ability to access update records
accessupdate = 1
if lloc = "School" then accessupdate = 0

sql = "SELECT emprecid, employeeno, employeelastnam e, employeefirstna me,
hrstatus, hrdate, budgetstatus, budgetdate, payrollstatus, payrolldate,
benefitdate, createdby, processstatus, employeetype, location FROM
employeetransac tion "

' we only display the records for the school location
' otherwise, we display all for departments

if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTrans action.PayrollD ate >=(date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTrans action.PayrollD ate >= (date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<>FALSE)) order by emprecid desc
"
end if

set rs = Conn.execute(sq l)

....
response.write sb(rs("hrstatus "))

function sb(s)
sb = s : if len(trim(sb)) = 0 then sb = "&nbsp;"
end function

rs.close: set rs = nothing
conn.close: set conn = nothing
--
http://www.aspfaq.com/
(Reverse address to reply.)


"wk6pack" <wk***@sd61.bc. ca> wrote in message
news:ed******** ******@TK2MSFTN GP09.phx.gbl...

Hi,

I'm getting this error on my asp page intermittently. One day it is fine,
another day, it crashes a lot. I have searched the web and microsoft on
this and they say it is a recordset assigned to a session variable.

I dont assign any record sets to session variables in my code. I assign
values to the session variables though.
The place it seems to crash is Set AccessConn =
Server.CreateOb ject("ADODB.Con nection")

code:

connstr = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" &
Server.mapPath( "EmployeeTransa ctions.mdb")
Set AccessConn = Server.CreateOb ject("ADODB.Con nection")
AccessConn.open connstr

'get session("loc") to see if they are allowed to update records
lloc = session("sploct ype")
loccode = session("sploca tiondesc")

'Determining the ability to access update records
if lloc = "School" then
accessupdate = 0
else
accessupdate = 1
end if

Set rs = Server.CreateOb ject("ADODB.Rec ordset")
sql = "select emprecid, employeeno, employeelastnam e, employeefirstna me,
iif(isnull(hrst atus),'&nbsp',h rstatus) as hrstatus,
iif(isnull(hrda te),'&nbsp',hrd ate) as hrdate,
iif(isnull(budg etstatus),'&nbs p',budgetstatus ) as budgetstatus,
iif(isnull(budg etdate),'&nbsp' ,budgetdate) as budgetdate," & _
" iif(isnull(payr ollstatus),'&nb sp',payrollstat us) as payrollstatus,
iif(isnull(payr olldate),'&nbsp ',payrolldate) as payrolldate,
iif(isnull(bene fitdate),'&nbsp ',benefitdate) as benefitdate,
iif(isnull(crea tedby),'&nbsp', createdby) as createdby,
iif(isnull(proc essstatus),'&nb sp',processstat us) as processstatus,
employeetype, location from employeetransac tion "

'we only display the records for the school location otherwise, we display
all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTrans action.PayrollD ate >=(date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTrans action.PayrollD ate >= (date()-30)) OR (Isnull([EmployeeTransac tion].[PayrollDate])<>FALSE)) order by emprecid desc "
end if
set rs = AccessConn.exec ute(sql)

Any ideas??
thanks,
Will

[Bob Barrows [MVP]]

Aaron [SQL Server MVP] wrote:

Several suggestions.

(a) don't use Server.CreateOb ject, just CreateObject

(b) what is set rs = Server.CreateOb ject("ADODB.Rec ordset") for? You
override it later with set rs = AccessConn.exec ute(sql) ... I also
changed "AccessConn " to a more standard "Conn"...

(c) don't do presentation things (replace null with "&nbsp;") in the
query. Do that where it belongs, in the presentation tier!

I do this in my query when I want to use GetString.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray Costanzo [MVP]]

How many people are hitting the site? Any time there are "intermitte nt"
errors that are Access database related, I'd say that they are often related
to concurrency issues and Access not being able/meant to handle lots of
connections.

As far as the code you included below, I'd drop the Set rs =
Server.CreateOb ject("ADODB.Rec ordset") line. What you're doing is creating
an empty recordset there, and then on the Set rs = AccessConn.Exec ute(sql)
line, you're destroying the recordset and creating a new one. So, it's a
microsecond of extra processing time there.

Also, instead of doing all that IsNull stuff in your query, I suggest
dropping all of that. What you can do instead is:

....
sql = "select emprecid, employeeno, employeelastnam e,
employeefirstna me,hrstatus,
hrdate,budgetst atus,budgetdate ,payrollstatus, payrolldate,ben efitdate,create dby,,processsta tus,
employeetype, location from employeetransac tion "
....

And then, after you get your recordset back, use .GetRows to dump the
recordset into an array. (Then quickly close and destroy your recordset and
ado connection!) With the GetRows method, you can convert all the nulls to
&nbsp; as such:

Set rs = AccessConn.Exec ute(sSQL)
If Not rs.EOF Then aData = rs.GetRows(2,,, "&nbsp;")
If you aren't sure what to do with the aData array then or haven't used
GetRows before and would like to know more about it, just post back here.

Ray at work
"wk6pack" <wk***@sd61.bc. ca> wrote in message
news:ed******** ******@TK2MSFTN GP09.phx.gbl...

Set rs = Server.CreateOb ject("ADODB.Rec ordset")
sql = "select emprecid, employeeno, employeelastnam e, employeefirstna me,
iif(isnull(hrst atus),'&nbsp',h rstatus) as hrstatus,
iif(isnull(hrda te),'&nbsp',hrd ate) as hrdate,
iif(isnull(budg etstatus),'&nbs p',budgetstatus ) as budgetstatus,
iif(isnull(budg etdate),'&nbsp' ,budgetdate) as budgetdate," & _
" iif(isnull(payr ollstatus),'&nb sp',payrollstat us) as payrollstatus,
iif(isnull(payr olldate),'&nbsp ',payrolldate) as payrolldate,
iif(isnull(bene fitdate),'&nbsp ',benefitdate) as benefitdate,
iif(isnull(crea tedby),'&nbsp', createdby) as createdby,
iif(isnull(proc essstatus),'&nb sp',processstat us) as processstatus,
employeetype, location from employeetransac tion "

'we only display the records for the school location otherwise, we display
all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTrans action.PayrollD ate >=(date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTrans action.PayrollD ate >= (date()-30))
OR
(Isnull([EmployeeTransac tion].[PayrollDate])<>FALSE)) order by emprecid
desc
"
end if
set rs = AccessConn.exec ute(sql)

[wk6pack]

thanks for the great suggestions. I'll try them and see what happens.

Will
"Aaron [SQL Server MVP]" <te*****@dnartr eb.noraa> wrote in message
news:OE******** ******@TK2MSFTN GP11.phx.gbl...

Several suggestions.

(a) don't use Server.CreateOb ject, just CreateObject

(b) what is set rs = Server.CreateOb ject("ADODB.Rec ordset") for? You
override it later with set rs = AccessConn.exec ute(sql) ... I also changed
"AccessConn " to a more standard "Conn"...

(c) don't do presentation things (replace null with "&nbsp;") in the query. Do that where it belongs, in the presentation tier! Wherever you have a
value coming back from the resultset that needs to be at least "&nbsp;", use the function I wrote below called sb (showblanks). Or, just response.write rs("column") & "&nbsp;" ... it makes your query much easier to read, doesn't it?

(d) make sure you close and destroy both the recordset object and the
connection object after you're done.
connstr = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" &
Server.mapPath( "EmployeeTransa ctions.mdb")
Set Conn = CreateObject("A DODB.Connection ")
Conn.open connstr

'get session("loc") to see if they are allowed to update records
lloc = session("sploct ype")
loccode = session("sploca tiondesc")

'Determining the ability to access update records
accessupdate = 1
if lloc = "School" then accessupdate = 0

sql = "SELECT emprecid, employeeno, employeelastnam e, employeefirstna me,
hrstatus, hrdate, budgetstatus, budgetdate, payrollstatus, payrolldate,
benefitdate, createdby, processstatus, employeetype, location FROM
employeetransac tion "

' we only display the records for the school location
' otherwise, we display all for departments

if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTrans action.PayrollD ate >=(date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTrans action.PayrollD ate >= (date()-30)) OR (Isnull([EmployeeTransac tion].[PayrollDate])<>FALSE)) order by emprecid desc "
end if

set rs = Conn.execute(sq l)

...
response.write sb(rs("hrstatus "))

function sb(s)
sb = s : if len(trim(sb)) = 0 then sb = "&nbsp;"
end function

rs.close: set rs = nothing
conn.close: set conn = nothing
--
http://www.aspfaq.com/
(Reverse address to reply.)


"wk6pack" <wk***@sd61.bc. ca> wrote in message
news:ed******** ******@TK2MSFTN GP09.phx.gbl...

Hi,

I'm getting this error on my asp page intermittently. One day it is fine, another day, it crashes a lot. I have searched the web and microsoft on
this and they say it is a recordset assigned to a session variable.

I dont assign any record sets to session variables in my code. I assign
values to the session variables though.
The place it seems to crash is Set AccessConn =
Server.CreateOb ject("ADODB.Con nection")

code:

connstr = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" &
Server.mapPath( "EmployeeTransa ctions.mdb")
Set AccessConn = Server.CreateOb ject("ADODB.Con nection")
AccessConn.open connstr

'get session("loc") to see if they are allowed to update records
lloc = session("sploct ype")
loccode = session("sploca tiondesc")

'Determining the ability to access update records
if lloc = "School" then
accessupdate = 0
else
accessupdate = 1
end if

Set rs = Server.CreateOb ject("ADODB.Rec ordset")
sql = "select emprecid, employeeno, employeelastnam e, employeefirstna me,
iif(isnull(hrst atus),'&nbsp',h rstatus) as hrstatus,
iif(isnull(hrda te),'&nbsp',hrd ate) as hrdate,
iif(isnull(budg etstatus),'&nbs p',budgetstatus ) as budgetstatus,
iif(isnull(budg etdate),'&nbsp' ,budgetdate) as budgetdate," & _
" iif(isnull(payr ollstatus),'&nb sp',payrollstat us) as payrollstatus,
iif(isnull(payr olldate),'&nbsp ',payrolldate) as payrolldate,
iif(isnull(bene fitdate),'&nbsp ',benefitdate) as benefitdate,
iif(isnull(crea tedby),'&nbsp', createdby) as createdby,
iif(isnull(proc essstatus),'&nb sp',processstat us) as processstatus,
employeetype, location from employeetransac tion "

'we only display the records for the school location otherwise, we display all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTrans action.PayrollD ate >=(date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTrans action.PayrollD ate >=

(date()-30)) OR

(Isnull([EmployeeTransac tion].[PayrollDate])<>FALSE)) order by emprecid

desc

"
end if
set rs = AccessConn.exec ute(sql)

Any ideas??
thanks,
Will

[Aaron [SQL Server MVP]]

> I do this in my query when I want to use GetString.

Why? GetString() supports NullExpr (which allow you to specify "&nbsp;" or
something else for any value that is Null).
http://msdn.microsoft.com/library/en...ordset)ado.asp

--
http://www.aspfaq.com/
(Reverse address to reply.)

[wk6pack]

Hi Ray,

I've got at least 30 people hitting the site to enter data into the Access
database.

I've never used .GetRows before. I would like to know more about it.

thanks,
Will
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:eo******** ******@TK2MSFTN GP15.phx.gbl...

How many people are hitting the site? Any time there are "intermitte nt"
errors that are Access database related, I'd say that they are often related to concurrency issues and Access not being able/meant to handle lots of
connections.

As far as the code you included below, I'd drop the Set rs =
Server.CreateOb ject("ADODB.Rec ordset") line. What you're doing is creating an empty recordset there, and then on the Set rs = AccessConn.Exec ute(sql)
line, you're destroying the recordset and creating a new one. So, it's a
microsecond of extra processing time there.

Also, instead of doing all that IsNull stuff in your query, I suggest
dropping all of that. What you can do instead is:

...
sql = "select emprecid, employeeno, employeelastnam e,
employeefirstna me,hrstatus,
hrdate,budgetst atus,budgetdate ,payrollstatus, payrolldate,ben efitdate,create d
by,,processstat us, employeetype, location from employeetransac tion "
...

And then, after you get your recordset back, use .GetRows to dump the
recordset into an array. (Then quickly close and destroy your recordset and ado connection!) With the GetRows method, you can convert all the nulls to &nbsp; as such:

Set rs = AccessConn.Exec ute(sSQL)
If Not rs.EOF Then aData = rs.GetRows(2,,, "&nbsp;")
If you aren't sure what to do with the aData array then or haven't used
GetRows before and would like to know more about it, just post back here.

Ray at work
"wk6pack" <wk***@sd61.bc. ca> wrote in message
news:ed******** ******@TK2MSFTN GP09.phx.gbl...

Set rs = Server.CreateOb ject("ADODB.Rec ordset")
sql = "select emprecid, employeeno, employeelastnam e, employeefirstna me,
iif(isnull(hrst atus),'&nbsp',h rstatus) as hrstatus,
iif(isnull(hrda te),'&nbsp',hrd ate) as hrdate,
iif(isnull(budg etstatus),'&nbs p',budgetstatus ) as budgetstatus,
iif(isnull(budg etdate),'&nbsp' ,budgetdate) as budgetdate," & _
" iif(isnull(payr ollstatus),'&nb sp',payrollstat us) as payrollstatus,
iif(isnull(payr olldate),'&nbsp ',payrolldate) as payrolldate,
iif(isnull(bene fitdate),'&nbsp ',benefitdate) as benefitdate,
iif(isnull(crea tedby),'&nbsp', createdby) as createdby,
iif(isnull(proc essstatus),'&nb sp',processstat us) as processstatus,
employeetype, location from employeetransac tion "

'we only display the records for the school location otherwise, we display all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTrans action.PayrollD ate >=(date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<> FALSE)) order by emprecid
desc "
else
sql = sql & " where ((EmployeeTrans action.PayrollD ate >= (date()-30))
OR
(Isnull([EmployeeTransac tion].[PayrollDate])<>FALSE)) order by emprecid
desc
"
end if
set rs = AccessConn.exec ute(sql)

[Aaron [SQL Server MVP]]

http://www.aspfaq.com/2467

--
http://www.aspfaq.com/
(Reverse address to reply.)


"wk6pack" <wk***@sd61.bc. ca> wrote in message
news:#E******** ******@TK2MSFTN GP14.phx.gbl...

Hi Ray,

I've got at least 30 people hitting the site to enter data into the Access
database.

I've never used .GetRows before. I would like to know more about it.

thanks,
Will
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:eo******** ******@TK2MSFTN GP15.phx.gbl...

How many people are hitting the site? Any time there are "intermitte nt"
errors that are Access database related, I'd say that they are often related

to concurrency issues and Access not being able/meant to handle lots of
connections.

As far as the code you included below, I'd drop the Set rs =
Server.CreateOb ject("ADODB.Rec ordset") line. What you're doing is

creating

an empty recordset there, and then on the Set rs = AccessConn.Exec ute(sql)

line, you're destroying the recordset and creating a new one. So, it's a microsecond of extra processing time there.

Also, instead of doing all that IsNull stuff in your query, I suggest
dropping all of that. What you can do instead is:

...
sql = "select emprecid, employeeno, employeelastnam e,
employeefirstna me,hrstatus,

hrdate,budgetst atus,budgetdate ,payrollstatus, payrolldate,ben efitdate,create d by,,processstat us,

employeetype, location from employeetransac tion "
...

And then, after you get your recordset back, use .GetRows to dump the
recordset into an array. (Then quickly close and destroy your recordset

and

ado connection!) With the GetRows method, you can convert all the nulls

to

&nbsp; as such:

Set rs = AccessConn.Exec ute(sSQL)
If Not rs.EOF Then aData = rs.GetRows(2,,, "&nbsp;")
If you aren't sure what to do with the aData array then or haven't used
GetRows before and would like to know more about it, just post back here.
Ray at work
"wk6pack" <wk***@sd61.bc. ca> wrote in message
news:ed******** ******@TK2MSFTN GP09.phx.gbl...

Set rs = Server.CreateOb ject("ADODB.Rec ordset")
sql = "select emprecid, employeeno, employeelastnam e, employeefirstna me, iif(isnull(hrst atus),'&nbsp',h rstatus) as hrstatus,
iif(isnull(hrda te),'&nbsp',hrd ate) as hrdate,
iif(isnull(budg etstatus),'&nbs p',budgetstatus ) as budgetstatus,
iif(isnull(budg etdate),'&nbsp' ,budgetdate) as budgetdate," & _
" iif(isnull(payr ollstatus),'&nb sp',payrollstat us) as payrollstatus,
iif(isnull(payr olldate),'&nbsp ',payrolldate) as payrolldate,
iif(isnull(bene fitdate),'&nbsp ',benefitdate) as benefitdate,
iif(isnull(crea tedby),'&nbsp', createdby) as createdby,
iif(isnull(proc essstatus),'&nb sp',processstat us) as processstatus,
employeetype, location from employeetransac tion "

'we only display the records for the school location otherwise, we

display all for departments
if lloc="School" then
sql = sql & " where location = '" & loccode & "' and
((EmployeeTrans action.PayrollD ate >=(date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<> FALSE)) order by emprecid desc "
else
sql = sql & " where ((EmployeeTrans action.PayrollD ate >= (date()-30)) OR
(Isnull([EmployeeTransac tion].[PayrollDate])<>FALSE)) order by emprecid desc
"
end if
set rs = AccessConn.exec ute(sql)

[Bob Barrows [MVP]]

Aaron [SQL Server MVP] wrote:

I do this in my query when I want to use GetString.

Why? GetString() supports NullExpr (which allow you to specify
"&nbsp;" or
something else for any value that is Null).

http://msdn.microsoft.com/library/en...ordset)ado.asp

It's not to replace Nulls.

In one instance, I do it pad hard spaces between pieces of data to simulate
columns in a SELECT. (so it will display say company number and company name
in columns in the SELECT) - I also concatenate all the OPTION tags in the
query as well (gasp!)

There's nothing like a simple

Response.Write rs.GetString

to reduce the amount of code on a page. This also cuts down on the number of
include files. This dropdown box is used in quite a few pages in which I
would have to #include the asp page to create the same option list that is
coming from my stored procedure. I see no point to doing this merely to
satisfy a theoretical "presentati on layer-data layer" division. Using such a
division is supposed to improve my codes maintainability , not reduce it.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray Costanzo [MVP]]

GetRows returns a two-dimensional array, where the first dimension
represents the columns in the recordset, and the second dimension represents
the rows, so to speak. So, if you had a query like:

"select firstname,lastn ame from people"

And you dumped that to an array with .GetRows, you'd iterate through it as
such:

<%

For i = 0 To UBound(aData, 2) '<-- the UBound of the second dimension
'''since the rows are in the second dimension
'''you want to loop through the number of times
'''as there are "records" in it.
Response.Write "Firstname = " & aData(0,i) & "<br>"
Response.Write "Lastname = " & aData(1,i) & "<hr>"
Next
%>
So, if you're used to working with arrays, it's just like having an array
like:

Dim someArray(1,5)
someArray(0,0) = "Bob" : someArray(1,0) = "Smith"
someArray(0,1) = "Ted" : someArray(1,1) = "Jones"
someArray(0,2) = "Jen" : someArray(1,2) = "Giles"
someArray(0,3) = "Kim" : someArray(1,3) = "Baron"
someArray(0,4) = "Ned" : someArray(1,4) = "Heinz"
someArray(0,5) = "Gus" : someArray(1,5) = "Baker"
Ray at work

"wk6pack" <wk***@sd61.bc. ca> wrote in message
news:%2******** ********@TK2MSF TNGP14.phx.gbl. ..

Hi Ray,

I've got at least 30 people hitting the site to enter data into the Access
database.

I've never used .GetRows before. I would like to know more about it.

thanks,
Will