|
 |
access thread: link from SQL
Message #1 by "nikola" <nikola@b...> on Sun, 16 Feb 2003 23:15:56 +0200
|
|
Hi All,
Can I connect mdb file with SQL Server 2000. To be more specific, my DB is separated in BE and FE, but some another application
using SQL Server and I need some information from one SQL server table and mast be linked because information in SQL table is
changing often.
Message #2 by "Bob Bedell" <bobbedell15@m...> on Mon, 17 Feb 2003 01:21:57 +0000
|
|
Hi Nikola,
Firt set up a DSN (data source name) using the ODBC Data
Source Administrator, then link to SQL Server just like
you'd link to an Access table via File | Get External Data.
=============================================================
Set up the DSN
=============================================================
1. You should see a Data Sources (ODBC) icon in your control
panel, or if you're using Windows 2K+ try
Programs | Administrative Tools | Data Sources from
the Start Menu.
2. Open the ODBC Data Source Aministrator. Click the System DSN
tab (all users will be able to use this DSN) and Click Add.
3. You'll see the ODBC drivers installed on yor computer displayed.
Select the SQL Server Driver. Click finish.
4. Supply a unique name for the new DSN. Enter the name of your
SQL Server or the string '(local)' if your SQL Server is on
the same machine. Click next.
5. Specifiy and authentication mode. Defaults are fine (Windows
authentication). Click Next.
6. Change defalut database to the database with the tables you
want to link to. Other default settings are fine. Click Next.
7. Defaults are fine. Click finish.
8. A dialog appears giving you the chance to test your
connection. Click OK. Your DSN is created and ready to use.
=============================================================
Link to SQL Server tables from Access
=============================================================
1. With SQL Server running, open Access, from the Access File
Menu select Get External Data | Link Tables.
2. In the Link dialog box select ODBC Databases from the 'File
of Type' drop down list.
3. From the Select Data Source dialog select the Machine Data
Source tab. You'll see the System DSN you created listed
(hopefully). Select it and click OK.
4. The Link Table dialog appears listing the tables in your SQL
Server database you can connect to. Select the table you want
and click OK.
5. The linked table appears in the tables pane of the Access
database window.
Hope it works for you...
>From: "nikola" <nikola@b...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] link from SQL
>Date: Sun, 16 Feb 2003 23:15:56 +0200
>
>Hi All,
>Can I connect mdb file with SQL Server 2000. To be more specific, my DB is
>separated in BE and FE, but some another application using SQL Server and
>I need some information from one SQL server table and mast be linked
>because information in SQL table is changing often.
>
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
Message #3 by "Nikola" <Nikola@b...> on Mon, 17 Feb 2003 09:24:58 -0000
|
|
BOB,
Thanks very mach, is working
Nikola
-----Original Message-----
From: Bob Bedell [mailto:bobbedell15@m...]
Sent: Monday, February 17, 2003 1:22 AM
To: Access
Subject: [access] Re: link from SQL
Hi Nikola,
Firt set up a DSN (data source name) using the ODBC Data
Source Administrator, then link to SQL Server just like
you'd link to an Access table via File | Get External Data.
=============================================================
Set up the DSN
=============================================================
1. You should see a Data Sources (ODBC) icon in your control
panel, or if you're using Windows 2K+ try
Programs | Administrative Tools | Data Sources from
the Start Menu.
2. Open the ODBC Data Source Aministrator. Click the System DSN
tab (all users will be able to use this DSN) and Click Add.
3. You'll see the ODBC drivers installed on yor computer displayed.
Select the SQL Server Driver. Click finish.
4. Supply a unique name for the new DSN. Enter the name of your
SQL Server or the string '(local)' if your SQL Server is on
the same machine. Click next.
5. Specifiy and authentication mode. Defaults are fine (Windows
authentication). Click Next.
6. Change defalut database to the database with the tables you
want to link to. Other default settings are fine. Click Next.
7. Defaults are fine. Click finish.
8. A dialog appears giving you the chance to test your
connection. Click OK. Your DSN is created and ready to use.
=============================================================
Link to SQL Server tables from Access
=============================================================
1. With SQL Server running, open Access, from the Access File
Menu select Get External Data | Link Tables.
2. In the Link dialog box select ODBC Databases from the 'File
of Type' drop down list.
3. From the Select Data Source dialog select the Machine Data
Source tab. You'll see the System DSN you created listed
(hopefully). Select it and click OK.
4. The Link Table dialog appears listing the tables in your SQL
Server database you can connect to. Select the table you want
and click OK.
5. The linked table appears in the tables pane of the Access
database window.
Hope it works for you...
>From: "nikola" <nikola@b...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] link from SQL
>Date: Sun, 16 Feb 2003 23:15:56 +0200
>
>Hi All,
>Can I connect mdb file with SQL Server 2000. To be more specific, my DB is
>separated in BE and FE, but some another application using SQL Server and
>I need some information from one SQL server table and mast be linked
>because information in SQL table is changing often.
>
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
|
|
|
View Cart
