Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How I can set Microsof Access for all user in NT 4

Status
Not open for further replies.

FluFFy05

Programmer
Jul 4, 2000
19
CA
My problem is that i what to start an appplication with a shedduler, around 6am, and they are nobody log in nt at this time. How I can know which user NT decide to execute MS Access with action queries who ask a confirmation to delete some row ?

I Would like set by default access for it accept an action queries without confirmation !!

Please help me !!

Fluffy
 
One way to do it would be to use a macro and at the start of the macro use the following:

Code:
DoCmd.SetWarnings False

This command tells access to turn warnings off and so you do not need to confirm any updates/deleteions etc. I have used this in scheduled invocations before and is very usefull.

James :) James Culshaw
jculshaw@active-data-solutions.co.uk
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top