how to patch a database

[Navarone]

I have a situation that requires me to update the database without losing any user information. I need to add a new table and add 2 fields to an existing table.

Can I do this using some sort of vb script when my application runs?

I am open to any ideas!

[brucevde]

You can execute Create Table and Alter Table sql statements against the database. The syntax would depend on which database you are using.

What data access technology are you using in your app, DAO or ADO?

[Navarone]

I am using MS Access Database with ADO.
This is how I am connecting to my db.

Sub CreateConnection(objConn As Connection)
 
' CONNECTION STRING FOR THE DATABASE
    AccessConnect = "DRIVER={Microsoft Access Driver (*.mdb)};" & _
                    "DBQ=Westfield.MDB;" & _
                    "DefaultDir=" & App.Path & ";"
 
    'MsgBox AccessConnect
 
    ' Create Connection Object and open it
    Set objConn = New ADODB.Connection
 
    objConn.CursorLocation = adUseClient
 
    ' Trap any error/exception
    On Error GoTo AdoError
 
    objConn.ConnectionString = AccessConnect
    objConn.Open
 
    Exit Sub
 
    ' ADO Error/Exception Handler
AdoError:
    ErrNumber = Err.Number
    ErrSource = Err.Source
    ErrDescription = Err.Description
 
    'AdoErrorEx List1, objConn
 
End Sub