> I have 2 servers; a web server and a file server.  I want an ASP on the

> web server to use an access DB on the file server.  Can this be done?  If

> so, how would I go about doing it?

> 

> Thanks,

> Eli

Not recommended for large Jet databases due to the amount of information

that might get pulled over the network.



The IUSR_webserver account is a local account that can not be added to the

share permissions on the file server, unless the webserver is also a PDC, or

you are running th webserver under a domain account.



Thus on the file server, create a local account that has the same name and

password as the IUSR_webserver account. Create a share, and give this new

account appropriate permissions to the share, and the file/folder where the

access database is.



Login on the webserver as the IUSR_webserver account. Map a drive letter to

the remote share on the file server. Put this new path in in your connection

string.



Cheers

Ken



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

----- Original Message -----

From: "Eli Schilling" <eschilli@t...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Wednesday, July 11, 2001 9:54 AM

Subject: [asp_database_setup] DSN-less remote connection





: > I have 2 servers; a web server and a file server.  I want an ASP on the

: > web server to use an access DB on the file server.  Can this be done?

If

: > so, how would I go about doing it?

: >

: > Thanks,

: > Eli