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

"arg1918" wrote:

> 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?

On Jul 19, 9:40 am, arg1918 <arg1...@discussions.microsoft.com> wrote:
> 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.