Understanding and Creating an Access Project

In the beginning there was a file based database product called MS Access. It had a terrific front end. Database administrators did not take it seriously, however, since it was small fry for them. SQL and Oracle databases were "the real stuff." But the real stuff was expensive, and did not have a front-end to speak of. For a while, you could use DTS to get data in and out of anywhere, including MS Access and SQL, and it was not a big deal. With an MS Access Project, you have a new construct. You may have data in SQL Server, but you can transparently see it in an Access database. It may have a few limitations, but it works well. This tutorial is about this new construct, available in MS Access 2000 onwards.


Read the full article here: Understanding and Creating an Access Project

For more discussion go here: Blog Article Discussion