John W. Colby
jcolby at colbyconsulting.com
Tue Nov 18 22:52:24 CST 2003
Awhile back I moved my client billing to SQL Server, just a simple upload of the mdb data, and then relinked to the ODBC. Nothing fancy. It all just worked. Now (since recovering EVERYTHING due to a hard disk crash), the LIKE keyword is causing failures in the odbc call. I use things like "LIKE forms!someform!somecontrol" etc. Now this fails (silently), just no data returned. Replace the LIKE with IN() and it works again. The TRULY strange part is that I use a LIKE ccfrmWhich() EVERYWHERE in order to only display active records in my forms. That fails in a combo, but succeeds in the form that hosts that combo. I do so love Access / SQL Server. John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com