However,  while MS provides the .mdb file (which does not match the SQL
DB!!>) they do not tell you how to accomplish the labs using Access instead
of SQL.  (how uncool)

I need help with the following line:
    ' *** beginning of code sample
    'open the recordset using argument for StudentID
    rsAccountBalance.Open "Select AccountBalance from Students Where
StudentID = " & Str(iStudentID), , cnStateUBookstore, adOpenStatic,
adLockReadOnly
    '*** end of code sample

I get a "Type Mismatch" error at this point.  The connection,
cnStateUBookstore, has been set before this code and used to retrieve data
successfully earlier in the program.

Any help would be appreciated.

Thank You,
David

If StudentID is a text field and iStudentID is an integer then change
your sql statement to this:

"Select AccountBalance from Students " & _
"Where StudentID = '" & Str(iStudentID) & "'"

else if you StudentID field is an integer then drop the Str() from the
sql statement.

As for SQL vs Access in the samples, I used Biblio as a substitute for
Pubs. Change the field refs and you should be ok.