reserved error (-3034)
mitch gilberg
with the description "there is no message for this error" ?
In Access 97, the exact appearance of the message is:
Reserved error (-3034); there is no message for this error.
[OK] [Help]
When you select [Help], the entire content of the help
screen is:
Reserved error <ITEM>; there is no message for this error.
(Error 3000)
An unexpected error occurred. The specified code
indicates the conditions under which this error can
occur. Please contact Microsoft Product Support Services
for more information.
I can't find anything in the Microsoft Knowledge Base
for "reserved error," "error 3034," "error -3034," "error
3000," or other seemingly reasonable combinations. The
error code list from Access gives "There is no message for
this error" for error 3000, and "You tried to commit or
roll back a transaction without first using BeginTrans" to
describe error code 3034. There was no attempted use of
Commit or RollBack at any time, so neither message is very
helpful.
I can provide more info on the process that is taking
place when the error occurs if that would be helpful.
However, the error occurs randomly. In multiple attempts
to execute the offending macro, sometimes it will work and
sometimes it doesn't. When it doesn't work, the point at
which it fails is unpredictable. In all cases, it is
using the same data, in the same database, on the same
computer. The macro queries linked tables on a network,
so network traffic may be a consideration.
Anyway, what I'm looking for is a way to identify what
happened based on the cryptic error message. Any advice?
Thanks!
...........mitch
Tony Toews
>Can anyone tell me how to identify the cause of an error
>with the description "there is no message for this error" ?
>
>In Access 97, the exact appearance of the message is:
>
>Reserved error (-3034); there is no message for this error.
>[OK] [Help]
Does the following seem to be your problem? Although it's not exactly
the same? PRB: Run-time Error '3043' When Using Books Online or DAO
Q175755 at the Knowledge Base at support.microsoft.com.
Doubtful though. It could be a corrupted MDB. Try importing all the
objects into a new MDB.
>"You tried to commit or
>roll back a transaction without first using BeginTrans" to
>describe error code 3034. There was no attempted use of
>Commit or RollBack at any time, so neither message is very
>helpful.
I think there's an implied commit/rollback whenever running an update
query but you mention linked tables.
Try deleting the linked tables and recreating the links.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
david epsom dot com dot au
than a VBA or DAO error. My guess is that some part
of the error handler assumes an Integer error number,
and the Application error number has mapped to a negative
integer from a number between 32K and 64K.
What is the actual action that is attempted giving an error?
And my suggestion is, use the wizard to convert your macro
to vba: you can handle errors like this more gracefully in
VBA than from a macro.
(david)
"mitch gilberg" <mgil...@aol.com> wrote in message
news:357001c2f8a8$4783a840$3101...@phx.gbl...