LINK REMOTE SQL SERVER 2000 Database

[Savas Ates]

I have a local mdb file and remote sql server 2000 database..

i know only my remote table user name and password...

my mdb file and sql database are same...

I tried to link my remote database

I click link table and odbc from my mdb...

i choose machine data source and new ...

i choose sql server and i write my server ip and click next....

i write my database username and password but it failss.

how can i link my remotet sql server 2000 database? what is my fault...
?

 

[G. Vaught]

You may need to setup a dsn on your own computer that points to the SQL
Server database. Be aware that if you are not the Administrator for this
database, you may not have the permissions needed to link a table from this
SQL Server to your mdb database. This is for good reason as this could give
you privileges that you are not authorized to have. I would contact the SQL
Server database administrator.