Administrator Shut Down
Nov 19, 2005any idea how i can use the attached DB to show a message box for 10 seconds and then automatically shut down??
View Repliesany idea how i can use the attached DB to show a message box for 10 seconds and then automatically shut down??
View RepliesI'm running into the issue where some of my batch files don't run correctly when the Access Application runs them.
Batch File:
Code:
FOR %%F IN ("*.prp") DO IF %%~zF EQU 0 DEL "%%F"
FOR %%F IN ("*.drv") DO IF %%~zF EQU 0 DEL "%%F"
start "" "%~dp0Start.bat"
I believe that this is because the For loops above are deleting files and don't have permissions to do it when ran from the application.
How I can modify this VBA to launch as Administrator?
VBA Snippet:
Code:
Shell parent_path & "Copy_" & Get2000Or2100 & ".bat"
I've created a query with a SWITCH component inside it. It
gave me the results i wanted but now if I try to see that query in Design View or run that
query, the entire database shuts down on me. So I'll have to create this query over again.
Is there any way I can avoid this in the future? Also is there any way of getting into the current
query that used to work, and fix it?
I know it can be done with task scheduling for a set time. However, I am looking for a way whereby the changing the time to shut off is very quick and easy to do as it would be continually done at different times. I have searched Google high and low but to no avail. I was hoping that I could have some VBA run with the On Timer event. The shut down would have to be done while the computer was either streaming a video or playing a radio station.
One simple way I could do it would be to pull the battery from a laptop and then have it plugged into one of those plugs that you just wind back for 60 minutes or 2 hours etc. before they shut off the power. However, would doing that corrupt Windows 8.1?
I am trying to link an excel file (.xlsb) into Access 2013 running on Windows 8 (External Data-->Excel). It will first act like it's working, but it will just shut Access down after a couple seconds of churning and ask for a Backup to be created or it will restart (no rhyme or reason as to which you will get). I've tried a Compact and Repair. I've tried rebooting. I've tried renaming the excel file(although I have other files with the same naming convention linked), but no matter what I do, it will not accept it. I've tried doing just a straight Import....same results. This file, along with a others that are already linked in this database, are stored on a network server.
View 7 Replies View Related