HOW TO...
All screen shots and instructions may differ slightly depending on your version of Windows and Office (Produced using Windows 2000 and Office 2000).
Open Access- Right Click in list area and choose Link Tables. This will bring up a file browsing widow.
- Under Files of Type, select ODBC Databases. This should bring up a Select Data Source window.
Change to tab Machine Data Source.- Click New. This will open a window entitled Create New Data Source.
Select User Data Source or System Data Source and click Next. Both selections change only sources for this machine. The differences is whether only you will be using access to the link or if everyone who is on this computer can link tables.
Select SQL Server and click Next.- Verify information then click Finished. Driver should be SQLServer.
Enter Name of data source. This is a unique name that you will need later in this link setup. A suggested name is "link" plus Server name you are linking to.- Optional. Enter description to remind user what this was for.
- Enter Server that you wish to link to. Make sure that the name is spelled exactly the same including upper and lower case.
- Click Next.
Choose With SQL Server authentication using a login ID and password entered by the user.- Verify that Connect to SQL Server to obtain default settings for the additional configuration options is checked.
- Enter Login ID and Password for SQL server then click Next.
Check Change the default database and select xspoc.- Click Next.
- Click Finished. This will bring up a verification screen.
- Click OK.
Double click name entered at setup 9. This should prompt for password.
Enter SQL user name and password. Click OK.
Select tables you wish to link and click OK. XSPOC tables are tables which start with "dbo.tbl".- You should now see tables selected in table list. You can now view and change values like a normal table.