>Connectivity error: [INTERSOLV][ODBC SQL Server driver][SQL Server]#all_accounts not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

OK, you're trying to access an object (table, stored procedure, view) that doesn't exist. You're accessing a table that begins with #. # is usually reserved for temporary tables that are scoped to the connection. Did you create the table on the same connection that you're trying to access it. How is #all_accounts created?

-Mike