Pseudo code for updating Access db using VB and ASP.NET

4 Apr 2006 7:39 PM

glenn

Hi folks,

I have been hunting for a code snippet to update an Access db using VB and
ASP.NET. So far, nothing that helps me. I am using OleDb libraries.

Can anyone provide me with the general steps or calls involved. Here is
where I am at so far. Any guidance would be great...

Sub UpdateRows()

   ' 1) OPEN A CONNECTION
   ' 2) GET EXISTING COLUMN DATA
   ' 3) PROVIDE AN UPDATE SQL STATEMENT
        '( NOT SURE WHAT THE SYNTAX SHOULD BE ON THIS)
   ' 4) USE OleDbParameter TO PASS IN THE UPDATES
        '( NOT SURE WHAT THE SYNTAX SHOULD BE ON THIS)
   ' 5) CLOSE THE CONNECTION

End Sub

6 Apr 2006 2:04 PM

Paul Clement

On Tue, 4 Apr 2006 12:39:05 -0700, glenn <gl***@discussions.microsoft.com> wrote:

¤ Hi folks,
¤
¤ I have been hunting for a code snippet to update an Access db using VB and
¤ ASP.NET. So far, nothing that helps me. I am using OleDb libraries.
¤
¤ Can anyone provide me with the general steps or calls involved. Here is
¤ where I am at so far. Any guidance would be great...
¤
¤ Sub UpdateRows()
¤
¤    ' 1) OPEN A CONNECTION
¤    ' 2) GET EXISTING COLUMN DATA
¤    ' 3) PROVIDE AN UPDATE SQL STATEMENT
¤         '( NOT SURE WHAT THE SYNTAX SHOULD BE ON THIS)
¤    ' 4) USE OleDbParameter TO PASS IN THE UPDATES
¤         '( NOT SURE WHAT THE SYNTAX SHOULD BE ON THIS)
¤    ' 5) CLOSE THE CONNECTION
¤
¤ End Sub

The following should help you get started:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office12062001.asp
http://support.microsoft.com/kb/821765/EN-US/

Paul
~~~~
Microsoft MVP (Visual Basic)