Example 1
The first example is really 5 examples.
The first four examples use SQL Server. These cannot run in the lab
at this time.
A developers version of SQL Server is packaged with VS.Studio
Example 2
Uses "flat files" and a class module to separate client
code from business logic.
Download the example
Example 3
Demonstrates n-tier design with the identical client (form) as
example two, but the class implements access to the database.
Using a UDL file, the database access can be switched between Access and
SQL Server with no changes to the class module.
Assignment
Much of this assignment has already been coded and should be downloaded. The .EXE is also available.
The program to be written is a database access program. The database
will contain both text and graphic columns.
You can adapt the program to whatever data suits your particular
interests.
Download the .EXE and the database
Download the model source code