my table name that I'm trying to open a recordset on is: "ijc_cmi" (1
underscore character). Before you ask: YES, IT EXISTS
MySql QueryBrowser (using same login credentials) can handle this fine:
"SELECT * FROM ijc_cmi"
Also, using same login credentials and an ADODataControl, this query "SHOW
TABLES" verifies that "ijc_cmi" is one of the tables in the DB
But, this query:
Set oRS = New ADODB.Recordset
oRS.Open "SELECT * FROM ijc_cmi", oConn
fails with a "table does not exist" error!?!?!?!?!?!
I've tried wrapping backticks around the `tablename` and that didn't help
nor did preceding the "_" with a "\" or doubling the "__" (which produced an
error "One or more errors occurred during processing of command." --
shouldn't it have also produced "table does not exist"? which leads me to
conclude it's a wildcard/escape character problem/solution)
I am obviously assuming that some escape character needs to be put in before
the "_" or wrap something around the tablename but I can't figure out what.
I suppose I'll also run into trouble with field names with "_", too.
I've searched and searched and can't see this tackled anywhere.