TechRepublic

Using Access to build a front end for SQL Server

Using Access to build a front end for SQL Server Your email has been sent What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your ...
Your Story

Why we need to convert an MS Access database to an MS SQL database and how to do it

This is a user generated content for MyStory, a YourStory initiative to enable its community to contribute and have their voices heard. The views and writings here ...
Ars Technica

Globally Transform a DataType in SQL Server DTS?

OK, here's the deal. I was importing a client's rickety Access database to SQL Server, using DTS. When doing so, every field in the Access database that had a type of DateTime came over as ...
Princeton University

E-commerce Database Design - Part II

Here are the details to two versions of Product Tables, one for Access 2000/97 and one for SQL Server 7. Not all of these fields are necessary in one database. For example, with Size and color you can ...