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

[Remco Groot Beumer]

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

[Jimbras]

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

[Remco Groot Beumer]

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