Hi,

I am using ADO 2.6 with datagrid in VB6 with SP5 on Win2k
On my form, I had a datagrid and ADO control with a command
button that had the code below.

Dim cn as ADODB.Connection
Dim rs as ADODB.Recordset

Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset

cn.CursorLocation = adUseClient
cn.Open "File Name=Outlet.udl"
rs.Open "outlet.dbf", cn, adOpenDynamic, adLockOptimistic, adCmdTableDirect

Set dbgrid.DataSource = rs
dbgrid.AllowUpdate = True
dbgrid.AllowAddNew = True
dbgrid.AllowDelete = True

rs.AddNew
rs.Update <------ this part give the error below

When I click the command button, it give the error below.
"Run-time error -2147467259 insufficient base table informations for updating
or refreshing"

What is wrong or did I miss out any setting. Please advise. Thank you