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