Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Other Development Tools
 Ms Access

Author  Topic 

Dilruba
Starting Member

2 Posts

Posted - 2007-11-12 : 11:03:25
I have used the following codes:


connectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\progam files\mail.mdb"

‘ execute the update

Set MM_editCmd = Server.CreateObject("ADODB.Command")

MM_editCmd.ActiveConnection = MM_editConnection

MM_editCmd.CommandText = sql

MM_editCmd.Execute

MM_editCmd.ActiveConnection.Close


snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-11-14 : 00:46:00
What error do you get? Try setting a breakpoint and take a look at the value in the sql variable right before it executes, you'll probably be able to see what is wrong. It looks to me like you might end up with a comma after the list of columns and values before the WHERE in the UPDATE statement that you generate.
Go to Top of Page
   

- Advertisement -