 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / July 2007Can I link an SQL database to my Outlook Contacts using Access?
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? Also I'm using Acess 2002 and Outlook 2002 > 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? "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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.