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.
--
TS Lim

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" <(E-Mail Removed)> wrote in message
newsCA93970-61E4-4B8F-A721-(E-Mail Removed)...
>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.
> --
> TS Lim

--
lts1509


"Alex Dybenko" wrote:

> 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" <(E-Mail Removed)> wrote in message
> newsCA93970-61E4-4B8F-A721-(E-Mail Removed)...
> >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.
> > --
> > TS Lim
>
> 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

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

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


"TS Lim" <(E-Mail Removed)> wrote in message
news:4CE0E9A8-AF0C-433D-B7E0-(E-Mail Removed)...
>
> --
> lts1509
>
>
> "Alex Dybenko" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> newsCA93970-61E4-4B8F-A721-(E-Mail Removed)...
>> >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.
>> > --
>> > TS Lim
>>
>> 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

Thanks Alex.

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

Regards,


TS Lim


"Alex Dybenko" wrote:

> Hi,
> sorry, I was wrong, there is no connection sting
> have a look here:
> http://www.outlookcode.com/threads.a...&messageid=620
> look at Ch23.bas
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
>
> "TS Lim" <(E-Mail Removed)> wrote in message
> news:4CE0E9A8-AF0C-433D-B7E0-(E-Mail Removed)...
> >
> > --
> > lts1509
> >
> >
> > "Alex Dybenko" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> newsCA93970-61E4-4B8F-A721-(E-Mail Removed)...
> >> >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.
> >> > --
> >> > TS Lim
> >>
> >> 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
>
>