Delete records produces page error

[alougher]

I'm trying to delete records from an access table using ADO. Everything works fine on my test server but when I put it into production it produces a "The page cannot be displayed" error. All other ADO commands such as INSERT and SELECT within the same script work ok.

Here is the code, any help appreciated:

dim dsn
dim Conn
dsn="DBQ=" & Server.Mappath("access_db\db.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
Set Conn = Server.CreateObject("ADODB.Connection")
conn.mode=3
Conn.Open dsn

sql="delete from contacts where contact_id=1;"
Set RS = Conn.Execute(SQL)

[niranjanc]

Hi ,
Check for the permission of the database by right clicking it..and viewing the permission ..you shld have full permission to delete the data..so do check that...

might be one of the reason..


Niranjan C

[Joseph_R_Thomas]

you also might want to verify the data you are trying to delete.