2000 Runtime Tools Menu?

[rod1968]

I have converted a database to Access2000 from Access95 and I have attempted to run them on a machine with Access Run-Time. However I am now getting prompts for confirmation of record deletions and appendments which I had suppressed on the Access95 Run-Time version.

It now seems impossible for me to change the Options menu settings in ACC2000 Run-Time, as the Tools menu is not available.

I need to find a way to set the Edit Options not to ask for comfirmation when running my .mdb in ACC2000 Run-Time.

Can anyone help me to find a solution to this please?

 

[K9Boxer]

I believe that this option exists at your database level. In MS A97, it is found under OPTIONS; EDIT/FIND. In development mode, try changing this setting, and redistributing the .mdb to the machines with RunTime installed.

Let me know if this helps.

 

[rod1968]

I'm still having problems

When ever I run an action query, a nag screen pops up for confirmation (Yes, No, Cancel). As I always want the action query to run, I have set the Options, Edit, Confirmation checkboxes to un-checked.

However, these options are not being set when I run the distribution copy on a Run-time application. And because MS have made Tools (and therefore Options) unavailable in ACC2000 Run-time, I have no way of changing this.

I have had some suggestions that it could be changed in code from within my database but I have not managed to do this.

Can any one help me please?

 

[K9Boxer]

Within your code, in the problem areas, place 'DOCMD.SETWARNINGS FALSE' prior to the execution of the offending code. After which you may elect to SETWARNINGS TRUE.

 

[rod1968]

Many thanks for your help, this has now proved to be the answer to my problems.