ODBC append Queries fail (repost)

  • Thread starter david epsom dot com dot au
  • Start date
D

david epsom dot com dot au

I am running a series of DAO append queries against tables linked to SQL
Server.

The queries are run inside a DAO transaction.

Sometimes the queries fail to complete. However, the transaction has already
been committed and the workspace object released. No exception is raised.


Is there any way to use workspace.begintrans and .committrans with linked
odbc tables?


(david)
 
Top