connect to text file via LAN

[Suawek]

hi,

in my database one of the tables is linked with text file on a server via
LAN. Unfortunately I have to use different login and password to get to the
server, so it fails when I want to get data automatically with my Windows
domain password.
How to refresh table using VBA given that the path is "\\comp-cz\results",
file name is "mytextfile.txt", login is "mylogin" and password "mypassword".
It seems to be much easier to connect to any 'genuine' database, but to
refresh query based on this external text file currently rerquires me to open
the mapped drive and use manually login and pswd (mapping the network drive
does not help - it still asks me to use login)

if it matters - Access 2003, Win XP

Thanks in advance

Slawek

 

[Douglas J. Steele]

How are you mapping the network drive? Take a look at what Randy Birch has
at http://vbnet.mvps.org/index.html?code/network/wnetaddconnection2.htm
(Obligatory warning: Randy's site is aimed at VB programmers, so the
examples often won't port directly into Access. This is one such case: he's
using a control array of command buttons, and Access doesn't support control
arrays. However, you should still be able to figure out what his code is
doing.)

Look at the ConnectNetDrive function, specifically at where he invokes
WNetAddConnection2. Randy's using birchr as the user id, and no password:
you'd replace vbNullString with the password.

 

[Suawek]

Thanks. I mapped it straight in Windows XP, I had no idea how to trigger it
with VBA. Will try the code then

Slawek

 

[Suawek]

is there any way that I can get the same effect using connection instead of
mapping the drive?

Slawek

 

[Douglas J. Steele]

I don't believe so. I don't think you'll be able to create a connection
without presenting your credentials, and I don't believe there's any way to
present credentials other than mapping.

 

[A a r o n K e m p f]

you need A c c e s s D a t a P r o j e c t s

 

[dbahooker]

Douglas is a known troll for whom the only answer is MDB, regardless
of the question

 

[Tom Wickerqueer]

you should use SQL Server and DTS in order to import the data

 

[Tom Wickernards]

or BCP.exe

you should use SQL Server and DTS in order to import the data