I have a series of records to add to different tables in a SQL Server 7.0 database.
The first thing I did was create a new workspace and opened the database. Then I used the WorkSpace.BeginTrans to start recording the transactions. The first set records okay but it hangs on the second set of transaction. The transactions are using DAO recordset and the AddNew method. Does anyone have any advice ??