Can I link an SQL database to my Outlook Contacts using Access?

G

Guest

We have contact data sitting in an SQL database and I would like it to be
viewed and updated live in Outlook. Is this possible? Is Access the correct
method to do this? How do I "double link" a file in Access so that it is
linked to an SQL database AND to outlook?
 
P

pietlinden

We have contact data sitting in an SQL database and I would like it to be
viewed and updated live in Outlook. Is this possible? Is Access the correct
method to do this? How do I "double link" a file in Access so that it is
linked to an SQL database AND to outlook?
Click to expand...

"double link"? What does that mean?
You can create links to external recordsources by using File, Get
External Data, Link... Then you can query them like normal Access
tables, but if I were using SQL Server, I'd link to a view or
something small... dragging tons of records across the network
wouldn't be a great idea.
 

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

Link outlook 2003 contacts with access 2003 database 1
LINK REMOTE SQL SERVER 2000 Database 1
Access database with SQL Server 4
Linking Access to Microsoft SQL 4
how to set permissions on tables - SQL LINK 1
Trouble with tables link from Access to SQL 3
Use Trusted Connection on SQL Link table 3
Using MS SQL 2000 with Access 6

Top