Asp page that connects to an Access Database on another computer?

[BJ]

How can I create an ASP page that connects to an Access Database on another computer. I an having problems with the user having permission to the database.

Should I create a user just for this or use NT permissions?

My web server is web1 and the database is located on a server fpr1. Everyone in the plant has access to this database. But the local Iuser on the web server doesn't.

Thanks
Brandon

[JoshT]

You have at least three choices:

1. Run the web server as a more priviledged user (probably a bad idea).

2. Lower the permissions on the database or share so that Everyone or Anonymous users have access to it. (Still lowers some security).

3. Move the DB to the web server if it won't cause other problems.