Setting up MS Access as an ODBC front end to Sybase

Steps:
- open Microsoft Access
- Create a new database (blank database)
- Select table tab, click "New" OR 
  File -> Get External Data -> Import
- select "files of type" to be ODBC()
- Click "machine data source" at the next dialog box:
- If you don't see the right source, click "New"
  - Select default "User Data Source," click Next
  - Double click on Sybase System 10 from the selection list
  - Click Finish: you'll now get a new Dialog box.  In the "General tab:
    Data Source Name: AIMS Devl
    Description: Aims Development server
    Server Name: DDEBT01DS1
    Database Name: aims
- Click apply when done, and you'll have a new DAta Source.  Click OK
and you've finished creating the new Data Source.

- If all goes well you'll have a "Logon to Sybase" dialog box.  Supply
username and password.  And you'll be presented a list of tables to import.

Notes: 
- You'll get ODBC errors if the user isn't granted select on the tables
you select.  

- you'll only be able to see tables that are in the GROUP of your
login...eg; i logged in as the dbo and couldn't see any of the tables owned

- All of this depends on having sql.ini somewhere available to ODBC.

---------------------------------
Setting up ODBC on your Windows Machine

- Start-> Settings-> Control Panel -> ODBC
(note, in Windows2000 the ODBC DAta sources menu is hidden under 
Start -> Settings -> Control Panel -> Administrative Tools -> ODBC

- Go to System DSN, select "Add."
- Scroll down the list of Drivers, select the Database System driver
you desire.  Click Finish
- Populate Name, optional description and Server name.  Hit Next.
(for Microsoft SQL SErver DSN configs)
- Change to SQL Server authentication, populate login/pw as the database
login and pw.  Click the client Configuration and ensure you're using tcp-ip.
Hit next.
- Change default database if desired.  Hit Next.
- Change any additional settings desired.  Hit finish.

Once done, make sure you Test Data Source!