I'm writing multiuser application using VB5 SP3 with DAO connects to PostgreSQL as database via ODBC.

The application allows user to update datbase. At the same time, there might be some timer events that import data files into the database without user interventions.

Should the application has one global workspace and connection object for all transactions? Or should I create a different workspace and/or connection object for each database queries (select, insert, update etc)?

If i'm using the global method, will the Begin/Commit/Rollback transaction for updating table A affect the transaction on table B? Since these methods are workspace properties.



Edited by carolyn on 03-07-2000 at 11:55 PM