The first problem was one user couldn't run my application. He had Windows XP with Sybase ASE odbc driver, and was getting Reserved Error (-7748) -- based on info posted on internet, we did the registry workaround, and he no longer gets an error, but the query just hangs.
This is the query:
INSERT INTO advcash_trades_staging
SELECT trim(str(acctnumb)) AS stracctnumb, *
WHERE effective_date=datevalue("05/13/2008") And (buyer_mnemonic='ADVCASH' Or seller_mnemonic='ADVCASH')
ORDER BY trade_date DESC;
dbo_pdp_cash_valuables is a link to a table that is in a Sybase database. advcash_trades_staging is a local table in Access. I can query the select part with no problem, and this successfully retrieves all 9500 rows, but the Insert does not complete on this user's PC. (it doesn't succeed in inserting even the first row.)
The two other users who have working queries have Windows 2000 with Sybase System 11 ODBC driver. I have tried removing the string conversion function, but the insert never happens. I have tried SELECT INTO and creating the table on the fly, but that doesn't work either.