I just ran into a bit of a roadblock. I have legacy code (that is no longer available to be modified) that accesses a Paradox table called QUEUE!A.DB, which is a perfectly valid filename and Paradox table name. I am trying to query this table via an ODBC SELECT statement, but ODBC fails because of the "!" in the filename (creating a copy of the table without the "!" works fine).
Any thoughts on how I can overcome this limitation? I can't rename the table in production (since the legacy program is looking for the original table name). Is there any way to set the table name at the DSN level? I'm open to using ADO instead of ODBC if that helps.
Any thoughts on how I can overcome this limitation? I can't rename the table in production (since the legacy program is looking for the original table name). Is there any way to set the table name at the DSN level? I'm open to using ADO instead of ODBC if that helps.