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

  • Thread starter Thread starter Joe Tsang
  • Start date Start date
J

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
 
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
 
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.
 
Back
Top