Here are the steps you need to follow to make a new link.
SQL Server Browser:
Sometimes it is useful to access SQL database from MS Access. Let's say you want to browse the data, change the data or test one of your triggers. Once you make a link to SQL Server using MS Access, you can do that.
| Here are the steps you need to follow to make a new link. |
---> File
---> Open Database
---> Tool
---> Add-Ins
---> SQL-Server Browser
---> Machine Data Source ---> New
---> User Data Source ---> Next
---> SQL Server ---> Next
---> Finish
---> Name:Enter kashef_testDB
Description:Enter test database
Server: Enter 164.136.42.145 ---> Next
---> Select SQL Server
Login ID: Enter SA
Password: Leave blank ---> Next
---> Select Change the default database to testDB ---> Next ---> Next ---> Finish
---> Test Data Source ---> OK
| If you already have a link created for SQL Server Browser, do the following to browse the data |
---> File
---> Open Database
---> Tool
---> Add-Ins
---> SQL-Server Browser
---> Machine Data Source
---> Select the created line ---> OK
--->Login ID: Enter SA
Password: Leave blank ---> OK
--->Select the appropriate table --->Open
| If you want to edit the database, do the following |
---> File
---> Open Database
---> Select Tables ---> New
---> Link Table ---> OK
---> Files of types: Select ODBC databases()
--->Machine Data Source
---> Select the created line ---> OK
--->Login ID: Enter SA
Password: Leave blank ---> OK
--->Select the appropriate table --->OK
Under tables, now you should be able to see the new linked table
---> Open
--->Now you can edit but remember this is a dynamic link! so don't change data by accident