Change Path Name for Outlook Linked Table

[TS Lim]

I have linked the contacts of in my MS Outlook 2007 in Access 2007 ACCDB. The
linked path was automatically created. Now I would like to change the path
name with VBA. How can do it ?

Please help.

Thank you.

 

[Alex Dybenko]

Hi,
Look at this code:
http://www.mvps.org/access/tables/tbl0009.htm

idea is the same, but you need to change connect string

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[TS Lim]

--
lts1509

Hi,
Look at this code:
http://www.mvps.org/access/tables/tbl0009.htm

idea is the same, but you need to change connect string

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com



Dear Alex,

Thanks for your prompt reply.

From the example in the code given, the specifier for Microsoft Acess
Database is [Database].

Kindly advise what is the specifier for Ms Outlook 2007 linked table.

Thanks you.

Best regards,
Lim

 

[Alex Dybenko]

Hi,
sorry, I was wrong, there is no connection sting
have a look here:
http://www.outlookcode.com/threads.aspx?forumid=2&messageid=620
look at Ch23.bas

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

--
lts1509

Hi,
Look at this code:
http://www.mvps.org/access/tables/tbl0009.htm

idea is the same, but you need to change connect string

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com



Dear Alex,

Thanks for your prompt reply.

From the example in the code given, the specifier for Microsoft Acess
Database is [Database].

Kindly advise what is the specifier for Ms Outlook 2007 linked table.

Thanks you.

Best regards,
Lim

 

[TS Lim]

Thanks Alex.

From your info, I have got a solution for my problem.

Regards,


TS Lim

Hi,
sorry, I was wrong, there is no connection sting
have a look here:
http://www.outlookcode.com/threads.aspx?forumid=2&messageid=620
look at Ch23.bas

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

--
lts1509

Hi,
Look at this code:
http://www.mvps.org/access/tables/tbl0009.htm

idea is the same, but you need to change connect string

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

I have linked the contacts of in my MS Outlook 2007 in Access 2007
ACCDB.
The
linked path was automatically created. Now I would like to change the
path
name with VBA. How can do it ?

Please help.

Thank you.

Thanks for your prompt reply.

From the example in the code given, the specifier for Microsoft Acess
Database is [Database].

Kindly advise what is the specifier for Ms Outlook 2007 linked table.

Thanks you.

Best regards,
Lim