ODBC Runtime Error 3146
Posted on 2002-05-29
Here is my delema. First I do not get this error on my computer. Second, when my boss runs this application and the VB program tries to access the MSAccess Report she gets:
"Runtime Error '3146'
Incorrect syntax near #170.."
What do you think I should do about this?
This is how I am accessing the MSAccess Report.
Private appAccess As Access.Application
Dim strWhere as String
Set appAccess = New Access.Application
strWhere = "(YTDAPHistory.DOCDATE > #" & txtEDate.Text & "#)"
appAccess.Visible = False
appAccess.OpenCurrentDatabase App.Path & "\VBMembers.mdb", True
.OpenReport "LCC-AP_Match", acViewPreview, , strWhere