Accessing an Access database from a Web Service

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

My team is developing a project where a client app needs to interact with a
remote Access database using a Web Service. The client app, the Web Service
and the database accessing layer are all implemented. The Access database
works fine in the server machine but when we try to interact with it using
the Web service, the database says "there are no permissions or the database
is blocked. I think it is not a permissions problem because we use admin
rights, so... which is the problem?

Thank you very much in advance.
 
I'm not sure what you mean by 'we use admin rights', but by default, ASP.NET
applications and web services run under the ASPNET operating system account.
You need to give this account read and write permission on the folder that
contains the database.
 
Sorry for my poor explanation. English is not my first language. By admin
rights I mean full permissions: read and write permissions both on the folder
and on the .mdb file for the ASP.NET account.

I can't think of any other possible problem related with permissions...
 
It sounds as though the ASPNET account has the necessary permissions. Are
you certain that the web service is running under that account? Also check
that no other application is opening the database exclusively. If neither of
those two things solves the problem, all I can suggest is to try asking the
question in an ASP.NET newsgroup.
 
Ok, thank you very much for your help.

Brendan Reynolds said:
It sounds as though the ASPNET account has the necessary permissions. Are
you certain that the web service is running under that account? Also check
that no other application is opening the database exclusively. If neither of
those two things solves the problem, all I can suggest is to try asking the
question in an ASP.NET newsgroup.
Click to expand...
 
Back
Top