can aybody help?

[kalyan]

Hi

Am using Access database for my web application developed in
asp(classic asp----not asp.net)

here is my code

set cnn=server.CreateObject("ADODB.Connection")
cnn.CursorLocation = 3
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
server.MapPath(".") & "\" & strbranch & "\" & strbranch &
".MDB;Persist Security Info=False"


am getting the error at the following line of code

cnn.Execute "Delete from table_one "


and the error is

Microsoft JET Database Engine error '80004005'
Could not delete from specified tables.


this code works fine im my local machine..but the problem arises when
i try 2 access the application by uploading files to the FTP provided
by my ISP

Earlier help is appreciated

Thanks & Regards
Kalyan

 

[Bob Barrows [MVP]]

Microsoft JET Database Engine error '80004005'
Could not delete from specified tables.

It's a peculiar error message that would have had me wondering if table_one
existed if you hadn't assured us that your code is successful on your local
machine. That assurance also prevents me from considering referential
integrity (foreign keys) issues.

I assume you have made sure the uploaded file's attributes are not set to
read-only ...

This leaves, as is usually the case with 80004005 errors: filesystem
permissions. All users of a Jet database file require Modify permissions for
the folder containing your database file, not just the file. This is to
enable the creation, modification and deletion of the .ldb file that is used
to control multi-user activity in the database file. In the case of an
internet website with Anonymous access enabled, this means that the
IUSR_MachineName user account requires that level of folder permissions, and
in some cases, the IWAM_MachineName account as well.