setting the access runtime-version

[Ive]

We have developed an application in Access 2000 and it works fine.

We deploy it by installing Access Runtime on the client-pc's and it works
fine also.

The only thing is that we should set "Confirm Record Changes, Action
Queries" to false.

Unfortunately, I didn't see such a setting yet in the runtime-version.

Any ideas?

Ive

 

[Arvin Meyer]

We have developed an application in Access 2000 and it works fine.

We deploy it by installing Access Runtime on the client-pc's and it works
fine also.

The only thing is that we should set "Confirm Record Changes, Action
Queries" to false.

Unfortunately, I didn't see such a setting yet in the runtime-version.

Any ideas?

You might simply change your code to turn off warnings at the start of an
Action Query, and off when it finishes, or you can use the Execute method
which doesn't prompt at all.


DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM tblWhatever"
DoCmd.SetWarnings True

OR:

CurrentDb.Execute "DELETE * FROM tblWhatever"
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Ive]

Yes,

Very nice!

Thanks for your answer and I can certainly use this in other projects.

Only problem is that in this particular projects, the queries are triggered
out of a Macro.

So how to do it in a Macro?

Ive