Message displayed when running action query...

[MrBo]

Hello
I have a database containing an action query.

When I open this by double-clicking the mdb file and double-click the action
query to run, I get some message prompts from Access (I know which prompts
are shown depends on the options selected in Tools-Options-Edit/Find-confirm
frame)

However when I open the database using a vb6 test exe code below, I get no
such prompts when double-clicking the action query to run.

Set objApp = New Access.Application
objApp.OpenCurrentDatabase ("mydb.mdb")
objApp.Visible = True

Any idea why this may be happening?

 

[Jeff Boyce]

We aren't there. We can't see the prompts. They may be informative for
"trouble-shooting"...

 

[Jeff Boyce]

Newsgroup netiquette asks that you not include attachments. Besides, your
odds of finding someone willing to download and open an unsolicited
attachment is a lot slimmer these days.

Perhaps you could post the SQL you're using via VB?

Regards

Jeff Boyce
<Access MVP>

 

[MrBo]

OK, here is all the detail in text:

I created an Office 2000 acess database - db1.mdb.
I created a table called Mailing List with one column FIRSTNAME.

I created a query using the following SQL:
UPDATE [Mailing List] SET FIRSTNAME = 'sdf';

If I open the database db1.mdb by clicking on it normally, ensure that
Tools-Options-Edit/Find Tab-Confirm frame-Action Queries tickbox is checked
then double click Query1 - I get the following two prompts:

"You are about to run an update query that will modify data in your table.
Are you sure you want to run this type of action query?
For information on how to prevent this message displaying every time you run
an action query, click Help.
Buttons Yes, No, Help.

You are about to update 13 row(s).
Once you click Yes, you cant use the Undo commnad to reverse the changes.
are you sure you want to update these records.
Buttons Yes, No.

The query runs if I select "yes" in both cases.

If I open the database from a test VB project using the code below then I do
not get these prompts when running the query - the query executes silently.

Set objApp = New Access.Application
objApp.OpenCurrentDatabase ("mydb.mdb")
objApp.Visible = True

I need to display these prompts so any idea why opening the db in this way
and running the query does not present the prompts?

Thanks

 

[Jeff Boyce]

Hmmm! I've not run into that situation before.

Have you tried searching at Google.com, too?

Regards

Jeff Boyce
<Access MVP>

OK, here is all the detail in text:

I created an Office 2000 acess database - db1.mdb.
I created a table called Mailing List with one column FIRSTNAME.

I created a query using the following SQL:
UPDATE [Mailing List] SET FIRSTNAME = 'sdf';

If I open the database db1.mdb by clicking on it normally, ensure that
Tools-Options-Edit/Find Tab-Confirm frame-Action Queries tickbox is checked
then double click Query1 - I get the following two prompts:

"You are about to run an update query that will modify data in your table.
Are you sure you want to run this type of action query?
For information on how to prevent this message displaying every time you run
an action query, click Help.
Buttons Yes, No, Help.

You are about to update 13 row(s).
Once you click Yes, you cant use the Undo commnad to reverse the changes.
are you sure you want to update these records.
Buttons Yes, No.

The query runs if I select "yes" in both cases.

If I open the database from a test VB project using the code below then I do
not get these prompts when running the query - the query executes silently.

Set objApp = New Access.Application
objApp.OpenCurrentDatabase ("mydb.mdb")
objApp.Visible = True

I need to display these prompts so any idea why opening the db in this way
and running the query does not present the prompts?

Thanks

Newsgroup netiquette asks that you not include attachments. Besides, your
odds of finding someone willing to download and open an unsolicited
attachment is a lot slimmer these days.

Perhaps you could post the SQL you're using via VB?

Regards

Jeff Boyce
<Access MVP>

then

I I
get

 

[MrBo]

Yes I have but as you will appreciate, it is quite a specialist query hence
the posting on this newsgroup.

Hmmm! I've not run into that situation before.

Have you tried searching at Google.com, too?

Regards

Jeff Boyce
<Access MVP>

OK, here is all the detail in text:

I created an Office 2000 acess database - db1.mdb.
I created a table called Mailing List with one column FIRSTNAME.

I created a query using the following SQL:
UPDATE [Mailing List] SET FIRSTNAME = 'sdf';

If I open the database db1.mdb by clicking on it normally, ensure that
Tools-Options-Edit/Find Tab-Confirm frame-Action Queries tickbox is checked
then double click Query1 - I get the following two prompts:

"You are about to run an update query that will modify data in your table.
Are you sure you want to run this type of action query?
For information on how to prevent this message displaying every time you run
an action query, click Help.
Buttons Yes, No, Help.

You are about to update 13 row(s).
Once you click Yes, you cant use the Undo commnad to reverse the changes.
are you sure you want to update these records.
Buttons Yes, No.

The query runs if I select "yes" in both cases.

If I open the database from a test VB project using the code below then

I

do
not get these prompts when running the query - the query executes silently.

Set objApp = New Access.Application
objApp.OpenCurrentDatabase ("mydb.mdb")
objApp.Visible = True

I need to display these prompts so any idea why opening the db in this way
and running the query does not present the prompts?

Thanks

then informative
for double-click
the

below,

I