Recent content by silenthillpsp

I found the solution. Thanks anyway.. Here is the code that saved my life :) Dim Cnxn As ADODB.Connection Dim rstsqlTablename As ADODB.Recordset Dim strCnxn As String Dim strSQL As String ' Open a connection Set Cnxn = New ADODB.Connection strCnxn =...

:D Hello Everyone, I have a database created in Access 2003 and same database in SQL server 2005. What I want to do is; update, delete, add data into SQL database using Access form.(with Command buttons) How can I connect and modify sql database from Access form and what codes I have to use...