ansaurus

Question

"Could not delete from specified tables" error only on published ASP.NET web site

Answer 1

A:

Does the database have the proper permisions setup? Have you verified you are able to connect to the database?

schooner 2009-04-27 10:06:31

i am using Access database...yes i can connect to database...

Girish1984 2009-04-27 10:07:57

Do you have read write access to the file where it is published? Has it perhaps be flagged read only?

schooner 2009-04-27 11:15:23

yes i do have read\write access to the file

Girish1984 2009-04-27 13:10:30

Answer 2

A:

Have a look at this link

http://support.microsoft.com/kb/240098

Huzefa 2009-04-27 10:07:13

Shouldn't matter on a single table delete. And, frankly, much as I appreciate the way DISINCTROW can make non-editable queries editable, I think one should avoid Jet-specific SQL as much as possible, since that will break if you change to a different back end database.

David-W-Fenton 2009-04-27 19:57:37

Answer 3

+1 A:

I doubt publishing a site can affect DB code functioning. Are you able to fetch data from the database, or does no database code work after publishing ?

Have you tried following this link? I am not sure if it solves your problem, but worth a try !

http://bytes.com/groups/asp/658763-could-not-delete-specified-tables

Preets 2009-04-27 10:14:07

Actually am using SQL server database.i will first empty access database by using the delete query and insert records from sql server to access...i was able to fetch records from SQL database..hope u got wat am trying to say

Girish1984 2009-04-27 10:21:01

http://bytes.com/groups/asp/658763-could-not-delete-specified-tables

Preets 2009-04-27 10:42:05

Answer 4

A:

I would check the ConnectionString of that data source. Check if the file is available in the directory you point to. Check also, if the Network Service account has the permission to change that file.

splattne 2009-04-27 10:25:34

Answer 5

A:

It is necessary for the user to have read, write and delete permissions on the directory where the Access database resides, because of the lock file (.ldb).

Remou 2009-04-27 23:52:11

i have given read\write permissions for the .mdb file but still i get this error

Girish1984 2009-04-28 03:37:26

It is necessary to have permissions on the folder in which the mdb is stored. The lock file (ldb) must be created on the first user in and deleted on the last user out and if there is any trouble, you can end up with a read-only database, no matter what the other permissions are.

Remou 2009-04-28 08:00:58

DELETE permission is not necessary. If the LDB is not deleted it causes no issues unless the LDB gets corrupted. Removing DELETE permission on the folder protects the main data file from deletion and changes LDB behavior to be like it was in Access 2 and before. You'd likely put your admini users in an NTFS user group that has DELETE permission in order that they can compact the data file (which requires a delete).

David-W-Fenton 2010-04-17 22:08:11

ansaurus

tags:

views:

answers:

"Could not delete from specified tables" error only on published ASP.NET web site

related questions