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
Martin Kulov - 16 Mar 2006 02:34 GMT
> Hi
> I use webservice to read/write data to Access database using
[quoted text clipped - 9 lines]
> Why webservice allow me to write to database on my computer but not on
> others.
Hi hulinning,
check if your ASP.NET account (ASPNET in WinXP or NETWORK SERVICE in
Win2003) has write permission to the Access file.
Regards,

Signature
Martin Kulov
http://www.codeattest.com/blogs/martin
MCT
MCSD.NET Early Achiever