Any error message?

There is a space in your file path just before ".mdb"

Tim


wrote in message
oups.com...
Dim MYdb As ADODB.Connection
Dim MYrs As ADODB.Recordset

MYdb.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents
and Settings\tsigwin\Desktop\Work Log .mdb;USER ID=admin;Password=;"
MYrs.Open "Select * from Work Log.Work Log", MYdb, adOpenDynamic,
adLockOptimistic



Any ideas?