Can't do any Delete/Insert/Update in Access

[Joe Tsang]

Hi

I am a new in using .net and I wrote a simple project working on
winxp. It works fine when doing any browse/delete/insert/update with
Access 2000, However when I moved those coding to windows 2003 server
with Access 2003, it only allows me to do the browse operation. I am
using OleDB Connection with Provider Microsoft.Jet.OLEDB.4.0 and I
also tried to do the Repair action in Access but failed. Am I suppose
to work with another Provider ? Or anyone know how to solve this
problem?

OleDbException (0x80004005): Could not delete from specified tables.]

Thanks
Joe

 

[Miha Markic [MVP C#]]

Hi Joe,

Can you verify that you have all the necessary NTFS privileges?

 

[Joe Tsang]

thanks for your reply , friend.

However, would you tell me how to verify the NTFS privileges?

Note: When I run the stored procedure in Access for Delete operation, it
works fine.

Regards
Joe

 

[Miha Markic [MVP C#]]

What type of application is yours (winforms, asp.net, service)?

 

[Joe Tsang]

I am using asp.net

regards
Joe

 

[Miha Markic [MVP C#]]

You should give "network service" local windows account (the accout used by
asp.net apps) read/write ntfs (file system) privileges on the access file
and folder where the file resides.

 

[Joe Tsang]

I see, thanks for your advice