I have an Access 2000 database which prompts on every delete/append action, eg: on opening it says "You are about to run a delete query that will modify data in your table" because there is a delete query in Autoexec. It runs without prompts on my PC (Windows NT) and also on my home PC (Windows ME) but when run on any other PC (regardless of OS) it prompts on every action. The functionality seems OK if you 'YES' through the endless prompts. Any suggestions.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Database prompts YES/NO/HELP on every action. 1
- Thread starter DNRUDGE
- Start date
-
1
- #3
If you are using VBA to execute then use this:
DoCmd.SetWarnings False
Before the code and
DoCmd.SetWarnings True
After the code
If you just want it turned off goto:
Tools->Options
Then click on the Edit/Find
Uncheck everything in the Confirm section of that tab
DoCmd.SetWarnings False
Before the code and
DoCmd.SetWarnings True
After the code
If you just want it turned off goto:
Tools->Options
Then click on the Edit/Find
Uncheck everything in the Confirm section of that tab
- Status
Similar threads
- Question
- Locked
- Question
- Question