|Thank you for responding to my question. I am using the following connection string to connect to a MIcrosoft Access database. I do NOT use the ADO data control; instead I define a connection object, a command object, and a recordset object and do ALL of my database access via code.|
"Provider=Microsoft.Jet.OLEDB.3.51;Data Source=" & THE_DATA_SOURCE & ";" & _
"Persist Security Info=True"
THE_DATA_SOURCE is simply the path name for my MS Access database.
Perhaps I need documentation on how MS Access implements SQL.
Thank you very much.