Does anyone know how to access an mdb file located in different machine
without using any third-party component?

Sam

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Lee, Samson (NIDCR)" <LeeS@e...>
Subject: [asp_web_howto] Accessing an MS Access file in different machine


: Does anyone know how to access an mdb file located in different machine
: without using any third-party component?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Yes. Remember:

a) that if the user does not provide Windows NT credentials then all file
access will be undertaken using the account configured in IIS as the
"anonymous internet user account". Typically this is called
IUSR_<machinename>. On all servers except domain controllers, this account
is a local account and can not be assigned permissions to remote resources.
You may need to change this to a domain account

b) that drive letters are mapped for the logged on user only, so don't try
to access a database via a drive letter that you have mapped to a remote
share, because that drive letter wont be mapped for the anonymous internet
user account. Use UNC (\\computer\share\folder) syntax instead.

Cheers
Ken