Link Access 97 to SQL

Hi! I'm a beginner in VB and I use MS Access 97. I would just like to
know how to link MS Access '97 database to a SQL Server 2000 database?
I just need to link a table from the SQL database which is in the
server. What are the procedures? Do I have to install SQL in my local
PC? Thank you!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
If you are asking about linking an Access database to SQL Server, then I am
sure it can be done, but not sure how exactly to do it. But if you are
talking about linking from SQL Server to Access, then yes, you can create a
linked server. See sp_addlinkedserver and sp_addlinkedsrvlogin in SQL Server
Books Online. This is completely documented with working examples in Books
Online.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Marilou Espiritu" <mallows13@.hotmail.com> wrote in message
news:%23D1ORMSiEHA.1040@.TK2MSFTNGP09.phx.gbl...
>
> Hi! I'm a beginner in VB and I use MS Access 97. I would just like to
> know how to link MS Access '97 database to a SQL Server 2000 database?
> I just need to link a table from the SQL database which is in the
> server. What are the procedures? Do I have to install SQL in my local
> PC? Thank you!
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||"Marilou Espiritu" <mallows13@.hotmail.com> wrote in message
news:%23D1ORMSiEHA.1040@.TK2MSFTNGP09.phx.gbl...
>
> Hi! I'm a beginner in VB and I use MS Access 97. I would just like to
> know how to link MS Access '97 database to a SQL Server 2000 database?
> I just need to link a table from the SQL database which is in the
> server. What are the procedures? Do I have to install SQL in my local
> PC? Thank you!
You need to minimally install the SQL Server Connectivity Only (this is an
option when you run the SQL Server install). You will probably also want the
Client Tools, though. Choosing to install the Client Tools also installs the
Connectivity. Next, create an ODBC Data Source. Control Panel | Data Sources
(this name could vary depending on your OS) | File DSN tab. Click Add...,
scroll down and choose the SQL Server driver and click Next. In the dialog
give a name to refer to the Data Source and click Next, then Finish. In the
Create dialog, optionally enter a Description, then choose the SQL Server
from the dropdown box. Click Next. The next screen asks how to login. Choose
an option and click Next. Change the Default database (starts as master) to
your database and click Next. Click Finish, you'll be prompted to test the
data source. Click test - if it succeeds - WooHoo! Click OK, and close out
of ODBC Administrator.
Now in Access, click File | Get External Data | Link Tables. In the dialog,
for type select ODBC. Choose the DSN file created above and click OK. Enter
the login information - you'll be presented with a list of tables on the SQL
Server. Select the one you want. If you don't want to be prompted for the
login info every time you access the table, check the Save password box.
Click OK. You can now use the table as though it were any other Access
table, with a few limitations. HTH!

> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!