Change Path Name for Outlook Linked Table

  • Thread starter Thread starter TS Lim
  • Start date Start date
T

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.
 
--
lts1509


Alex Dybenko said:
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,
Click to expand...

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


TS Lim said:
--
lts1509


Alex Dybenko said:
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,
Click to expand...

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
Click to expand...
 
Thanks Alex.

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

Regards,


TS Lim


Alex Dybenko said:
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


TS Lim said:
--
lts1509


Alex Dybenko said:
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.
Click to expand...

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
Click to expand...
Click to expand...
 
Back
Top