I am able to delete record from specified table when I just run the program from visual studio 2008. I am using ms access as database. My connection string is:
Provider=Microsoft.Jet.OLEDB.4.0;data source=" + @Directory.GetCurrentDirectory() + "\\smsmanager.mdb;Jet OLEDB:Database Password=matmat
However, after setup and deployed in Program Files folder and try to delete record from ms access db, I got the error saying "Could Not Delete from Specified Tables".
Please kindly advice on this issue. I have tried to google it but to no avail where this website provide no valued information: http://support.microsoft.com/default.aspx?kbid=240098.