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

Runtime acc2000 asks to confirm (at delete, insert etc.)

P: n/a
Hello,

I've developed a Microsoft Access 2000 database. In a lot of events
Docmd.RunSQL is used. In my database options the 'Confirm' options are
turned off, so I don't have to confirm action queries. The SQL statements
are executed behind the scenes this way.

But When I run the same database with a runtime version of Microsoft Access
2000, I have to confirm the actionqueries that are executed with
Docmd.RUnSQL again. For each SQL statement, the confirmation-question is
shown on the screen. Since I don't see the option to change this settings in
the runtime version I wonder how to solve this?

Does anyone know how to solve this problem?

Greetings,
Chris
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
hi, Chris,

when working with access runtime and you need to change options you must use
code.

try this:

if application.getOption("Confirm Action Queries") = true then
Application.SetOption ("Confirm Action Queries"), False 'change
parameter to false (don't have to confirm action queries)
end if

Regards

"Remco Groot Beumer" <te***********@12move.nl> escreveu na mensagem
news:ce**********@news2.tilbu1.nb.home.nl...
Hello,

I've developed a Microsoft Access 2000 database. In a lot of events
Docmd.RunSQL is used. In my database options the 'Confirm' options are
turned off, so I don't have to confirm action queries. The SQL statements
are executed behind the scenes this way.

But When I run the same database with a runtime version of Microsoft Access 2000, I have to confirm the actionqueries that are executed with
Docmd.RUnSQL again. For each SQL statement, the confirmation-question is
shown on the screen. Since I don't see the option to change this settings in the runtime version I wonder how to solve this?

Does anyone know how to solve this problem?

Greetings,
Chris


Nov 13 '05 #2

P: n/a
Thanks very much...this is exactly what i'm looking for. I'm currently
searching some other settings which can be adjusted like this.

Thankxs very much

"Jimbras" <al****@microsoft.com> schreef in bericht
news:41**********************@news.telepac.pt...
hi, Chris,

when working with access runtime and you need to change options you must use code.

try this:

if application.getOption("Confirm Action Queries") = true then
Application.SetOption ("Confirm Action Queries"), False 'change
parameter to false (don't have to confirm action queries)
end if

Regards

"Remco Groot Beumer" <te***********@12move.nl> escreveu na mensagem
news:ce**********@news2.tilbu1.nb.home.nl...
Hello,

I've developed a Microsoft Access 2000 database. In a lot of events
Docmd.RunSQL is used. In my database options the 'Confirm' options are
turned off, so I don't have to confirm action queries. The SQL statements are executed behind the scenes this way.

But When I run the same database with a runtime version of Microsoft Access
2000, I have to confirm the actionqueries that are executed with
Docmd.RUnSQL again. For each SQL statement, the confirmation-question is
shown on the screen. Since I don't see the option to change this

settings in
the runtime version I wonder how to solve this?

Does anyone know how to solve this problem?

Greetings,
Chris


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.