LINK REMOTE SQL SERVER 2000 Database

S

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access & SQL Server 2000 "Personal Edition" 2
SQL Database - How to Link to? Other Questions? Help? 2
Am I disturbing a machine in production floor if I access its database remotely? 4
Access 2.0 link to Sql Server 3
Easy way to copy records from one table to another in code? 7
Linking ODBC Tables for Multiple Users 7
Access Frontend to SQL database 2
upsize to sql server 6

Top