|
-
August 1st, 2004, 08:56 AM
#1
Delete records produces page error
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)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|