setting the access runtime-version

  • Thread starter Thread starter Ive
  • Start date Start date
I

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
 
Ive said:
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?
Click to expand...

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
 
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
 
Back
Top