Invalid Page Fault Error while invoking Execute method of Ado connection object

[Santosh]

Some times while invoking the Execute method of Ado connection object, the following error is coming.

VB6 caused an invalid page fault in module syutl95.dll

Every time dll name will be different some of them are msflxgrd.ocx,tabctl32.ocx,ivutl3.dll,kernel32.dll,wininet.dll,ssscc.dll,<unknown>

If any one knows the solution pleas reply.

thanks,


Santosh N
Sr. Software Engineer,
Wipro Infotech, India.

[Jorge Ramirez]

Maybe, that error is because the execute method is only for add records to a table like this:

dim db as database
dim sInsert as string
'Insert query. Appends a record with "Jorge" and
' 23 in fields Name and Age
sInsert="INSERT INTO Students (Name,Age) Values ('Jorge',23);"
'Open database
set db=opendatabase("C:\My Documents\School.mdb")
'Execute the query
db.execute sInsert
'Close the database
db.close
'Free memory
set db=nothing





I hope this help you
Jorge Ramirez