How do I edit/view data in a SQL database?

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

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. and double clicking will give a graphical view.