Urgent---Remote connection to sql server

  • Thread starter Thread starter Keri
  • Start date Start date
K

Keri

how do i connect remotely to sql server 2000 from Ms-
Access 2000?

Many Thanks,
Keri
 
You have to setup the ODBC definition on your system. For
help with that, I would check with the DBA for the
database. There are just to many variations for me to walk
you through that. You do this from the Control Panel.

Next, from the File menu, choose GetExternal Data\Link
Tables. From File Type, choose ODBC. You will then have to
pick your database from the choices presented.

Hope that helps!

Kevin
 

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

Back
Top