dotnet web services: Hi
I use webservice to read/write data to Access database using
System.Data.OleDb with a connection string =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source;User Id=admin;Password="

I can read/write on my developed computer without any problem.

However, When I install my webservice on other computers for testing, My
webservice could not write to Access database anymore. I can read only.

I got an an error message when updating database is 'Operation must use an
updatable query', and a different error message when I try to delete a record
is 'Could not delete from the specified table'.

Why webservice allow me to write to database on my computer but not on others.

I even try to install the webservice on my computer and it works too.

Thanks a lot for any comments

[quoted text, click to view]

Hi hulinning,

check if your ASP.NET account (ASPNET in WinXP or NETWORK SERVICE in
Win2003) has write permission to the Access file.

Regards,

--
Martin Kulov
http://www.codeattest.com/blogs/martin

MCT
MCSD.NET Early Achiever