Slow Down and Think
I know, it's 2014 and we shouldn't have to think anymore, but let's just take a moment and think for a bit anyway. You might have seen news about an internet-enabled refrigerator sending spam emails lately, which might seem minor but it indicates a bigger problem of internet enabled devices that have zero or minimal security built in.
Intro to the Site Maintenance project
Warning: This post is outdated. It is here for reference purposes only.
I've written before about an automated website backup and restoration tool, but I've left the overall picture rather vague so far. This post will start to remedy that problem. I've decided to call the project "Site Maintenance" but I'm not very good at naming things, so I apologize for its blandness. This post will go over the main features of the project from a "why would I want it?" point of view. Let's get started...
Creating a Web Interface for SQL Server Powered Application
This post covers how to get an ASP.NET Web Application to connect to the DEMO SQL database we created here. This is not a full tutorial on creating Web Applications, but instead focuses on how to connect the project to a database.
If you have already followed that mini-series, you ended up with an MS Access database as a UI. This post assumes you've followed at least the first post and have created the database DEMO with the three tables, two views, and one stored procedure.
Connecting SQL and MS Access - Part 3
So far in this series we created a basic database in SQL Server 2012 Express with a few tables, views and a stored procedure. Then in the second part we created the shell of our MS Access front-end, created a DSN file and connected two views on the SQL Server to Access. In this third (and final!) post of the series we will create a form in MS Access that allows a user to create a new person record and assign them to a department using the stored procedure we developed in the first post. As with the prior posts, I'm assuming a level of familiarity with the systems being discussed, such as SQL Server and MS Access.
Connecting SQL and MS Access - Part 2
In Part 1 of "Connecting SQL and MS Access" we created a basic database in SQL Server with three tables, two views and one stored procedure. In this post we're going to create a MS Access front-end database and link it to the views we created. We won't link to the base tables because we want all data access filtered through the views and stored procedures. If you are using a version other than Access 2007 or 2010 your steps may vary.
Mastodon