I have a job that needs to run with all connections stopped in to my database, I would like to have the system go to single user mode (I think this is the correct way but may not) and complete the job at end of the job bring the system back on-line.
what is the best way to do this?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…