How to connect from MS Access to Sybase
Revised 4/23/2001

0. Log in to NT.  From Unix you can do use the "wincenter" command to do
   this:
	majors:    "wincenter -h stdnt"
	nonmajors: "wincenter -h labnt"
   where "h" stands for "host".  Your default NT password is the same
   as your default Unix password.

1. Start up MS Access.
2.1 On first use:
    Specify "Create a New Database Using", "Blank Database".
    Specify it's name and where to store the mdb file.
2.2 On subsequent uses:
    Specify Open an Existing Database." and select the appropriate
    one.
3. Link tables from Sybase.
    3.1 Choose "File". 
	"Get External Data."
	"Link Tables ..."
    3.2 "Link" window appears.
	Under "Files of Type:" select "ODBC Databases."
    3.3 Under "Select Data Source" Window, choose "Machine Data Source".
	Select "Course Database Server" and "OK".
    3.4 Under "Logon to Sybase" window, choose "Server Name" 'coursedb' from
	pull-down menu.
	Enter your Unix Login name.
	Enter your Sybase password.
	Specify your class database ("cXXXyy"), where "XXX" is your
	course number, e.g. 670 or 671 and "yy" are the letters for your
	particular section.
	"OK".
    3.5 Select whichever tables you want to use.

Warning: Be sure to create the tables before entering a session to
link them to MS Access.  Otherwise you may be able to "link" the
tables, but will get an error when you actually try and use the
tables.  If this problem occurs, just close your MS Access DB and then
reopen it.