This page contains only the obvious. Make sure that you have the correct number of commas. Make sure that you have spelt your variables, table names and ADO constants properly. If you are specifying a tablename or a stored procedure name then these must be enclosed in " marks: strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db1.mdb" objRS.Open "table1", strConnect, adOpenForwardOnly, adLockReadOnly, adCmdTable However if you are just passing in a variable (eg see strConnect above) then you do not need " marks. Step 2 - Define your ADO constants. Back to FAQ listing.