web service remote access database

[carlblanchard]

Hey all.

Ive got Server 1 running IIS
Server 2 is my database server, running SQL + access databases

i just wrote a webservice to handle data to and from an access database, however i am getting some security issues saying the following

<?xml version="1.0" encoding="utf-8" ?>
<anyType xmlns:q1="http://www.w3.org/2001/XMLSchema" d1p1:type="q1:string" xmlns:d1p1="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://tempuri.org/WSMarketingSubscriber/Service1">System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file '\\dbserver\Databases\Db1.mdb'. It is already opened exclusively by another user, or you need permission to view its data. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at WSMarketingSubscriber.WSMarketingDI.Unsubscribe() in E:\Inetpub\wwwroot\WSMarketingSubscriber\WSMarketingDI.vb:line 46</anyType>

Can any one tell me what user account i need for the access database, in order for my webservice to work......

Many Thanks

[carlblanchard]

OK ive done some checking and move the access db to local machine tested and it worked fine, so its got something to do with security account, i blocked the asp.net system account from the local access db and it gave same error, so when unblocked it worked fine, question is now how do i get the asp.net account to work on server 2