Hi Eric,

Could u please check for me this preview coding. I can update the record but I can't preview the record. Before I use the same coding for Access 97 0LEDB.3.51.

Dim BookRec As New ADODB.Recordset
Dim BookCon As New ADODB.Connection

Private Sub Form_Load()
BookCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book\Book.mdb;Persist Security Info=False"
BookRec.ActiveConnection = BookCon.ConnectionString
BookRec.Open "Select * from Book", , adOpenStatic, adLockReadOnly
Set DataGrid1.DataSource = BookRec
End Sub

Thank you.