MS Access 2010/2007 database to manage SQL Server scripts
Submitted by magicscreen on Friday, March 25, 2011 - 03:14.
Language
This application allows the user to manage SQL Server scripts. It also allows the user to place SQL Server .SQL scripts in a "Run Once" Windows folder or in a general "Run Whenever" Windows folder.
The scripts can be prioritized so they run in a specific order, if necessary.
The program works with Windows Logon as well as SQL Server Logon.
The code was written using MS Access 2010 but I tested it using MS Access 2007 and it seems to work as well. I did not do an exhausting test in MS Access 2007.
There is another program called TextMaker Viewer 2010 that should be installed. It allows the user to view the Log Files from the program. The log files are created in Windows Folders. You can get it at http://www.officeviewers.com/. This is a FREE program.
Uncheck ALL associations so this program does not become the main program to view them unless you want it to be.
I would have included it in the zip file but then the file would exceed the 2 MB limit.
There is a user document file included in the zip file.
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.
Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Comments
interested to learn MySQL through MS-Access 2007
How to start MySQL can u refer the book name in near future?
Add new comment
- Add new comment
- 175 views