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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top