adOpenStatic Logo
Navigation
Home
Resources
ASPMSAccess FAQ
Contact Ken
Copyright 2000 -




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.