ACCESS FEED: [MS_AccessPros] Re: Network Drive with password

Rabu, 02 Mei 2012

[MS_AccessPros] Re: Network Drive with password

Hi Fathan,

You need to map the drive to your computer. Ensure you tick the
"Reconnect at logon" and enter password by selecting "connect using a
different user name" option. This way your computer will automatically
connect to the network drive during startup. and you can keep the same
existing code.

Cheers!

M N Yogananda

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca"
<wrmosca@...> wrote:
>
> Hi Fathan
>
> Stupid IT guys! If you can log on to your network why would you need
to log on to a mapped drive?!
>
> Oh well. I'm glad I don't have to contend with that. Please let us
know if acravenrohm (name?) got you what you need.
>
> Bill Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com, "Fathan" fathan02@
wrote:
> >
> >
> > //sorry, resent due incomplete msg//
> >
> > Hi Bill,
> >
> > Thank you..
> >
> > I have vba code in my excel (in my computer) to
> > make connection with access file in network drive in LAN of my
office.
> >
> > It used to work until our IT guys set up a password to the map
drive.
> >
> > Now, I need to open the network drive using window explorer (one
time only) before running the vbcode with my excel file.
> >
> > Regards
> >
> >
> >
> > Fathan Haras
> >
> > -----Original Message-----
> > From: "Bill Mosca" wrmosca@
> > Sender: MS_Access_Professionals@yahoogroups.com
> > Date: Mon, 30 Apr 2012 16:17:51
> > To: MS_Access_Professionals@yahoogroups.com
> > Reply-To: MS_Access_Professionals@yahoogroups.com
> > Subject: [MS_AccessPros] Re: Network Drive with password
> >
> > Fathan
> >
> > I'm not sure if there is a way or not. But I can look into it as
time permits.
> >
> > Can you tell us a little more about what you need to accomplish?
> >
> > Regards,
> > Bill Mosca, Founder - MS_Access_Professionals
> > http://www.thatlldoit.com
> > Microsoft Office Access MVP
> > https://mvp.support.microsoft.com/profile/Bill.Mosca
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Fathan" <fathan02@>
wrote:
> > >
> > >
> > > Dear all,
> > >
> > > Can we open network drive with password thru vb code instead of go
to window explorer and type the password ?
> > >
> > > Thank you in advance for your guidance.
> > >
> > > Regards,
> > > Fathan
> > > Fathan Haras
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>