Migrating from Access 2000 to SQL Server 2000 - MS Access: User Created Objects
(Page 2 of 6 )
The starting point is the MS Access database that is to be migrated to SQL Server 2000. For the sake of demonstration this database contains five tables (a subset of the Northwind.mdb) with the relationship as shown in the picture.
The MS Access file has other objects as shown based on the following query. This query has data from all the related tables.
SELECT Employees.LastName, Employees.FirstName, Customers.CompanyName, Customers.ContactName, Products.ProductName, Orders.RequiredDate, [Order Details].Quantity
FROM (Customers INNER JOIN (Employees INNER JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID) ON Customers.CustomerID = Orders.CustomerID) INNER JOIN (Products INNER JOIN [Order Details] ON Products.ProductID = [Order Details].ProductID) ON Orders.OrderID = [Order Details].OrderID;
Migrating from MS Access 2000 to SQL 2000 Server
A form based on the above query is shown below. This form has two sub-forms, Orders and Order details. For each employee it looks up the orders they have taken. Also for each order the order details are shown.
A report based on the query is shown here. This is based on the query grouped by Company Name as shown.
This is a Data Access Page hosted on the intranet server. The DAP is saved to the web root and it can be accessed by the intranet.
Next: Creating a SQL 2000 Server database >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
/ 14 
