By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,473 Members | 3,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,473 IT Pros & Developers. It's quick & easy.

Can't stop the query? Strange DLL error

P: n/a
Mal
Greetings.
I have a perplexing problem....please help.

I am having a problem with an insert query. (SQL below)

When I run the query via code (executing the SQL string) it crashes
Access and gives me a Page Fault error in OLEAUT32.dll

When I run the query from the query window it gives the normal "You
are about to run an action query..." then appears to run, yet DOES NOT
give the "You are about to Add 4 rows" message.

When I then close the query (which I can do) and open the table that
is supposed to hold the result....it's not there...

And then trying to close this table results in an
"This Action will reset in break mode - Yes / No" message...
Clicking yes simply repeats the error message adnauseum, clicking No
leaves you in the table with the same problem on trying to close...

So what code is still running?? The insert query? Then why can I close
it?

and any ideas why when the same query is run in code it crashes the
APP.

This behaviour is identical on all machines here at work.
they all are running Office 2000
Some on Windows 98
some on Windows 98se

The ONLY machine that performs correctly is a WinXP laptop running
Office XP.

Any ideas???
Mal.

QUERY SQL IS AS FOLLOWS....beware word wrap..

INSERT INTO tblWebProfile ( lngProfileID, strFName, strMI, strLName,
strAddress, strCity, lngStateID, strZip, strHomePhone, strWorkPhone,
strExt, blnDependant, mmoDependNotes, strEMail, lngConfMethodID,
blnFlag1, blnFlag10, blnFlag2, blnFlag3, blnFlag4, blnFlag5, blnFlag6,
blnFlag7, blnFlag8, blnFlag9, strField1, strField10, strField2,
strField3, strField4, strField5, strField6, strField7, strField8,
strField9, strRefferedBy, strRelationship, strSpouseFName,
strSpouseLName, strSpousePhone )
SELECT [_tblTempWebData].lngProfileID, StrConv(strPFName,3) AS Expr1,
[_tblTempWebData].strPMI, StrConv(strPLName,3) AS Expr2,
StrConv(strPAddress,3) AS Expr3, StrConv(strPCity,3) AS Expr4,
[_tblTempWebData].lngPStateID, [_tblTempWebData].strPZip,
[_tblTempWebData].strPHomePhone, [_tblTempWebData].strWorkPhone,
[_tblTempWebData].strExt, [_tblTempWebData].blnDependant,
First([_tblTempWebData].mmoDependNotes) AS FirstOfmmoDependNotes,
[_tblTempWebData].strPEMail, [_tblTempWebData].lngConfMethodID,
[_tblTempWebData].blnPFlag1, [_tblTempWebData].blnPFlag10,
[_tblTempWebData].blnPFlag2, [_tblTempWebData].blnPFlag3,
[_tblTempWebData].blnPFlag4, [_tblTempWebData].blnPFlag5,
[_tblTempWebData].blnPFlag6, [_tblTempWebData].blnPFlag7,
[_tblTempWebData].blnPFlag8, [_tblTempWebData].blnPFlag9,
First([_tblTempWebData].strPField1) AS FirstOfstrPField1,
First([_tblTempWebData].strPField10) AS FirstOfstrPField10,
First([_tblTempWebData].strPField2) AS FirstOfstrPField2,
First([_tblTempWebData].strPField3) AS FirstOfstrPField3,
First([_tblTempWebData].strPField4) AS FirstOfstrPField4,
First([_tblTempWebData].strPField5) AS FirstOfstrPField5,
First([_tblTempWebData].strPField6) AS FirstOfstrPField6,
First([_tblTempWebData].strPField7) AS FirstOfstrPField7,
First([_tblTempWebData].strPField8) AS FirstOfstrPField8,
First([_tblTempWebData].strPField9) AS FirstOfstrPField9,
[_tblTempWebData].strRefferedBy, [_tblTempWebData].strRelationship,
StrConv(strSpouseFName,3) AS Expr5, StrConv(strSpouseLName,3) AS
Expr6, [_tblTempWebData].strSpousePhone
FROM _tblTempWebData
GROUP BY [_tblTempWebData].lngProfileID, [_tblTempWebData].strPMI,
[_tblTempWebData].lngPStateID, [_tblTempWebData].strPZip,
[_tblTempWebData].strPHomePhone, [_tblTempWebData].strWorkPhone,
[_tblTempWebData].strExt, [_tblTempWebData].blnDependant,
[_tblTempWebData].strPEMail, [_tblTempWebData].lngConfMethodID,
[_tblTempWebData].blnPFlag1, [_tblTempWebData].blnPFlag10,
[_tblTempWebData].blnPFlag2, [_tblTempWebData].blnPFlag3,
[_tblTempWebData].blnPFlag4, [_tblTempWebData].blnPFlag5,
[_tblTempWebData].blnPFlag6, [_tblTempWebData].blnPFlag7,
[_tblTempWebData].blnPFlag8, [_tblTempWebData].blnPFlag9,
[_tblTempWebData].strRefferedBy, [_tblTempWebData].strRelationship,
[_tblTempWebData].strSpousePhone, [_tblTempWebData].strPFName,
[_tblTempWebData].strPLName, [_tblTempWebData].strPAddress,
[_tblTempWebData].strPCity, [_tblTempWebData].strSpouseFName,
[_tblTempWebData].strSpouseLName
ORDER BY [_tblTempWebData].lngProfileID;
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I ran your sql through my formatter tool ... and with some additional
formatting in Word, I came up with the script that follows. I don't
see anything that looks wrong, but my first suspicion would be on the
table that begins with an underscore. Does it crash if you remove it?

.... or at least change this line
FROM _tblTempWebData
to this ... with brackets
FROM [_tblTempWebData]

INSERT INTO tblWebProfile
( lngProfileID
, strFName
, strMI
, strLName,strAddress
, strCity
, lngStateID
, strZip
, strHomePhone
, strWorkPhone,strExt
, blnDependant
, mmoDependNotes
, strEMail
, lngConfMethodID,blnFlag1
, blnFlag10
, blnFlag2
, blnFlag3
, blnFlag4
, blnFlag5
, blnFlag6,blnFlag7
, blnFlag8
, blnFlag9
, strField1
, strField10
, strField2,strField3
, strField4
, strField5
, strField6
, strField7
, strField8,strField9
, strRefferedBy
, strRelationship
, strSpouseFName,strSpouseLName
, strSpousePhone )

SELECT
[_tblTempWebData].lngProfileID
, StrConv(strPFName,3) AS Expr1

, [_tblTempWebData].strPMI
, StrConv(strPLName,3) AS Expr2

, StrConv(strPAddress,3) AS Expr3
, StrConv(strPCity,3) AS Expr4

, [_tblTempWebData].lngPStateID
, [_tblTempWebData].strPZip

, [_tblTempWebData].strPHomePhone
, [_tblTempWebData].strWorkPhone

, [_tblTempWebData].strExt
, [_tblTempWebData].blnDependant

, First([_tblTempWebData].mmoDependNotes) AS FirstOfmmoDependNotes

, [_tblTempWebData].strPEMail
, [_tblTempWebData].lngConfMethodID

, [_tblTempWebData].blnPFlag1
, [_tblTempWebData].blnPFlag10

, [_tblTempWebData].blnPFlag2
, [_tblTempWebData].blnPFlag3

, [_tblTempWebData].blnPFlag4
, [_tblTempWebData].blnPFlag5

, [_tblTempWebData].blnPFlag6
, [_tblTempWebData].blnPFlag7

, [_tblTempWebData].blnPFlag8
, [_tblTempWebData].blnPFlag9

, First([_tblTempWebData].strPField1) AS FirstOfstrPField1

, First([_tblTempWebData].strPField10) AS FirstOfstrPField10

, First([_tblTempWebData].strPField2) AS FirstOfstrPField2

, First([_tblTempWebData].strPField3) AS FirstOfstrPField3

, First([_tblTempWebData].strPField4) AS FirstOfstrPField4

, First([_tblTempWebData].strPField5) AS FirstOfstrPField5

, First([_tblTempWebData].strPField6) AS FirstOfstrPField6

, First([_tblTempWebData].strPField7) AS FirstOfstrPField7

, First([_tblTempWebData].strPField8) AS FirstOfstrPField8

, First([_tblTempWebData].strPField9) AS FirstOfstrPField9

, [_tblTempWebData].strRefferedBy
, [_tblTempWebData].strRelationship

, StrConv(strSpouseFName,3) AS Expr5
, StrConv(strSpouseLName,3) ASExpr6
, [_tblTempWebData].strSpousePhone
FROM _tblTempWebData
GROUP BY
[_tblTempWebData].lngProfileID
, [_tblTempWebData].strPMI

, [_tblTempWebData].lngPStateID
, [_tblTempWebData].strPZip

, [_tblTempWebData].strPHomePhone
, [_tblTempWebData].strWorkPhone

, [_tblTempWebData].strExt
, [_tblTempWebData].blnDependant

, [_tblTempWebData].strPEMail
, [_tblTempWebData].lngConfMethodID

, [_tblTempWebData].blnPFlag1
, [_tblTempWebData].blnPFlag10

, [_tblTempWebData].blnPFlag2
, [_tblTempWebData].blnPFlag3

, [_tblTempWebData].blnPFlag4
, [_tblTempWebData].blnPFlag5

, [_tblTempWebData].blnPFlag6
, [_tblTempWebData].blnPFlag7

, [_tblTempWebData].blnPFlag8
, [_tblTempWebData].blnPFlag9

, [_tblTempWebData].strRefferedBy
, [_tblTempWebData].strRelationship

, [_tblTempWebData].strSpousePhone
, [_tblTempWebData].strPFName

, [_tblTempWebData].strPLName
, [_tblTempWebData].strPAddress

, [_tblTempWebData].strPCity
, [_tblTempWebData].strSpouseFName

, [_tblTempWebData].strSpouseLName
ORDER BY
[_tblTempWebData].lngProfileID;
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"Mal" <ma******@hotmail.com> wrote ...
Greetings.
I have a perplexing problem....please help.

I am having a problem with an insert query. (SQL below)

When I run the query via code (executing the SQL string) it crashes
Access and gives me a Page Fault error in OLEAUT32.dll

When I run the query from the query window it gives the normal "You
are about to run an action query..." then appears to run, yet DOES NOT
give the "You are about to Add 4 rows" message.

When I then close the query (which I can do) and open the table that
is supposed to hold the result....it's not there...

And then trying to close this table results in an
"This Action will reset in break mode - Yes / No" message...
Clicking yes simply repeats the error message adnauseum, clicking No
leaves you in the table with the same problem on trying to close...

So what code is still running?? The insert query? Then why can I close
it?

and any ideas why when the same query is run in code it crashes the
APP.

This behaviour is identical on all machines here at work.
they all are running Office 2000
Some on Windows 98
some on Windows 98se

The ONLY machine that performs correctly is a WinXP laptop running
Office XP.

Any ideas???
Mal.

Nov 12 '05 #2

P: n/a
Mal
I will need to return to work to try the code you provided.
however...
If the _tblTempWebData table is empty....(actually it has header row
imported from the txt file that creates it...but no data)
then the code won't crash at all....
strange...

Mal.

"Danny J. Lesandrini" <dl*********@hotmail.com> wrote in message
news:bt************@ID-82595.news.uni-berlin.de...
I ran your sql through my formatter tool ... and with some additional
formatting in Word, I came up with the script that follows. I don't
see anything that looks wrong, but my first suspicion would be on the
table that begins with an underscore. Does it crash if you remove it?

... or at least change this line
FROM _tblTempWebData
to this ... with brackets
FROM [_tblTempWebData]

INSERT INTO tblWebProfile
( lngProfileID
, strFName
, strMI
, strLName,strAddress
, strCity
, lngStateID
, strZip
, strHomePhone
, strWorkPhone,strExt
, blnDependant
, mmoDependNotes
, strEMail
, lngConfMethodID,blnFlag1
, blnFlag10
, blnFlag2
, blnFlag3
, blnFlag4
, blnFlag5
, blnFlag6,blnFlag7
, blnFlag8
, blnFlag9
, strField1
, strField10
, strField2,strField3
, strField4
, strField5
, strField6
, strField7
, strField8,strField9
, strRefferedBy
, strRelationship
, strSpouseFName,strSpouseLName
, strSpousePhone )

SELECT
[_tblTempWebData].lngProfileID
, StrConv(strPFName,3) AS Expr1

, [_tblTempWebData].strPMI
, StrConv(strPLName,3) AS Expr2

, StrConv(strPAddress,3) AS Expr3
, StrConv(strPCity,3) AS Expr4

, [_tblTempWebData].lngPStateID
, [_tblTempWebData].strPZip

, [_tblTempWebData].strPHomePhone
, [_tblTempWebData].strWorkPhone

, [_tblTempWebData].strExt
, [_tblTempWebData].blnDependant

, First([_tblTempWebData].mmoDependNotes) AS FirstOfmmoDependNotes

, [_tblTempWebData].strPEMail
, [_tblTempWebData].lngConfMethodID

, [_tblTempWebData].blnPFlag1
, [_tblTempWebData].blnPFlag10

, [_tblTempWebData].blnPFlag2
, [_tblTempWebData].blnPFlag3

, [_tblTempWebData].blnPFlag4
, [_tblTempWebData].blnPFlag5

, [_tblTempWebData].blnPFlag6
, [_tblTempWebData].blnPFlag7

, [_tblTempWebData].blnPFlag8
, [_tblTempWebData].blnPFlag9

, First([_tblTempWebData].strPField1) AS FirstOfstrPField1

, First([_tblTempWebData].strPField10) AS FirstOfstrPField10

, First([_tblTempWebData].strPField2) AS FirstOfstrPField2

, First([_tblTempWebData].strPField3) AS FirstOfstrPField3

, First([_tblTempWebData].strPField4) AS FirstOfstrPField4

, First([_tblTempWebData].strPField5) AS FirstOfstrPField5

, First([_tblTempWebData].strPField6) AS FirstOfstrPField6

, First([_tblTempWebData].strPField7) AS FirstOfstrPField7

, First([_tblTempWebData].strPField8) AS FirstOfstrPField8

, First([_tblTempWebData].strPField9) AS FirstOfstrPField9

, [_tblTempWebData].strRefferedBy
, [_tblTempWebData].strRelationship

, StrConv(strSpouseFName,3) AS Expr5
, StrConv(strSpouseLName,3) ASExpr6
, [_tblTempWebData].strSpousePhone
FROM _tblTempWebData
GROUP BY
[_tblTempWebData].lngProfileID
, [_tblTempWebData].strPMI

, [_tblTempWebData].lngPStateID
, [_tblTempWebData].strPZip

, [_tblTempWebData].strPHomePhone
, [_tblTempWebData].strWorkPhone

, [_tblTempWebData].strExt
, [_tblTempWebData].blnDependant

, [_tblTempWebData].strPEMail
, [_tblTempWebData].lngConfMethodID

, [_tblTempWebData].blnPFlag1
, [_tblTempWebData].blnPFlag10

, [_tblTempWebData].blnPFlag2
, [_tblTempWebData].blnPFlag3

, [_tblTempWebData].blnPFlag4
, [_tblTempWebData].blnPFlag5

, [_tblTempWebData].blnPFlag6
, [_tblTempWebData].blnPFlag7

, [_tblTempWebData].blnPFlag8
, [_tblTempWebData].blnPFlag9

, [_tblTempWebData].strRefferedBy
, [_tblTempWebData].strRelationship

, [_tblTempWebData].strSpousePhone
, [_tblTempWebData].strPFName

, [_tblTempWebData].strPLName
, [_tblTempWebData].strPAddress

, [_tblTempWebData].strPCity
, [_tblTempWebData].strSpouseFName

, [_tblTempWebData].strSpouseLName
ORDER BY
[_tblTempWebData].lngProfileID;
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"Mal" <ma******@hotmail.com> wrote ...
Greetings.
I have a perplexing problem....please help.

I am having a problem with an insert query. (SQL below)

When I run the query via code (executing the SQL string) it crashes
Access and gives me a Page Fault error in OLEAUT32.dll

When I run the query from the query window it gives the normal "You
are about to run an action query..." then appears to run, yet DOES NOT
give the "You are about to Add 4 rows" message.

When I then close the query (which I can do) and open the table that
is supposed to hold the result....it's not there...

And then trying to close this table results in an
"This Action will reset in break mode - Yes / No" message...
Clicking yes simply repeats the error message adnauseum, clicking No
leaves you in the table with the same problem on trying to close...

So what code is still running?? The insert query? Then why can I close
it?

and any ideas why when the same query is run in code it crashes the
APP.

This behaviour is identical on all machines here at work.
they all are running Office 2000
Some on Windows 98
some on Windows 98se

The ONLY machine that performs correctly is a WinXP laptop running
Office XP.

Any ideas???
Mal.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.