Warning messages

[Tim]

I'm using Access 2002. I have an MDB that I've converted to an MDE and
is being used by several users. I've found out that when the database
runs as an MDE that all error messages and warnings no longer appear.
For example, when you delete a record, you don't get the warning about
"You are about to delet a record...". Or if you type something into a
combo box with the LimitToList property set to Yes that is not in the
list, it just refuses the input with no error messages or anything. I
never turn off the warnings and have even tried explicity to turn them
on. What's going on?

 

[Rick Brandt]

I'm using Access 2002. I have an MDB that I've converted to an MDE and
is being used by several users. I've found out that when the database
runs as an MDE that all error messages and warnings no longer appear.
For example, when you delete a record, you don't get the warning about
"You are about to delet a record...". Or if you type something into a
combo box with the LimitToList property set to Yes that is not in the
list, it just refuses the input with no error messages or anything. I
never turn off the warnings and have even tried explicity to turn them
on. What's going on?

Something else. Converting to an MDE does not affect any of these settings
or behaviors.

These are USER settings BTW, not FILE settings. You would have to examine
how each user has these settings configured for their installation of
Access.

 

[Tim]

That's what doesn't make sense to me. For starters, I don't know of any
user setting that turns off the delete warning that Access gives when
you delete a record or turns off VB error messages. In any case, I have
a VBScript that runs the MDE and also checks the "Confirm Document
Deletions" so it is always on. On one user's computer, I personally
checked her options, explicitly set warnings to on and then tried
deleting a record at both the form level and the table level. No
warning message. Just boom - record gone. What user setting turns off
all error messages?

 

[Rick Brandt]

That's what doesn't make sense to me. For starters, I don't know of any
user setting that turns off the delete warning that Access gives when
you delete a record or turns off VB error messages.

Tools
Options
[Edit / Find]
"Confirm"
x Record Changes
x Document Deletions
x Action Queries

The option for "Record Changes" also applies to deletions. A "Documant
Deletion" is when you delete an *object* like an entire form or report.

 

[Tony D'Ambra]

Check the Confrim section of Edit/Find tab under Tools Options. Also, is
there a line of code containing:

SetWarnings False

that is not reset to SetWarnings True on completion of a process or in the
Error-handling code?

 

[Tim]

I finally figured out at least part of it. I have my users running the
database using a shortcut to a VB Script that copies the MDE to the C:
drive and runs it from there. If I run the MDE directly, I get the
warnings correctly. If I run it using the VB Script, no warnings. Now
for some digging...