A. SQL 6.5 and earlier versions do not come with tools to directly view/edit the data in the SQL database visually. SQL 7.0 will include such a tool however in the meantime there are a number of options available.
The first item is to create an ODBC link to the SQL database (unless it is the local server)
- Start the ODBC control panel applet (Start - Settings - Control Panel - ODBC)
- Under User Data Sources will be a list of data sources you can connect to. Click Add
- Select SQL Server and click Finish
- Enter a name for the source, a description and a server name/IP address. Click Next
- Select the type of authentication and enter a username and password if applicable. Click Next
- You can set the default database by clicking "Change the default database to" and selecting one. Click Next
- Select character translation (except default) and click Next
- Select log options and click Finish
- At the end a summary will be displayed and click "Test Data Source" to perform a brief test. Click OK to complete
- Close the ODBC dialog box by clicking OK
Now you have the connection you need to configure Access to use it
- Start Access 97
- Select Blank Database and click OK
- Enter a name and directory, click Create
- Select the Tables tab
- From the File menu select Get External Data - Link Tables
- In the bottom left corner of the displayed dialog will be "Files of type:". Change this to "ODBC databases"
- A new dialog will be displayed. Click the "Machine Data Source" tab
- Select the Data Source created using ODBC earlier and click OK
- You may need to enter a password for the database.
- You will now see "Link Table" dialog, select and click OK.
- Under your main Table tab you will now see dbo.<database> and double clicking will give a graphical view.