Thanks Jim and Jamie. This is what I was looking for. I think I like the
method of writing my own SQL statements the best. I just wasn't sure how to
pass them through.

I appreciate the input.

chris

"Jamie Collins" wrote:

"Jim Thomlinson" wrote ...

Here is how I send a record to an Access Database. <<snipped

If that's one approach then here's another, using SQL DML:

Option Explicit

'Declare Module Level Constants
Private Const m_cDBLocation As String = "\\C:\Forecast.mdb"
Private Const m_cLogFile As String = "tblLogFile"

Public Sub LogIn()
Dim cnt As Object
Set cnt = CreateObject("ADODB.Connection")

' Open connection to the database
With cnt
.ConnectionString = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & m_cDBLocation
.Open
.Execute _
"INSERT INTO " & m_cLogFile & _
" ([User Name], [In As], Logged, [Time])" & _
" VALUES ('Me', 'Myself', 'In', NOW);"
.Close
End With
End Sub

Jamie.

--