Thread: Commit to a linked database
02-03-11, 10:46 #1Registered User
- Join Date
- Oct 2003
- Near D.C.
Unanswered: Commit to a linked database
We have a process that is extensive enough, that it locks down usage of the tables it is working on for the length of time it runs.
Access 2007 linked tables to DB2 LUW 9.7 using ODBC.
Is there any way to trigger a commit within DB2 from Access for a certain period within the whole process?
So we don't have to wait until the end.
I was pondering a Save command, as a step within the macro,
or embedded within VBA.
Haven't had the chance to try it out yet.
But any input or methods from anyone else would be appreciated.
02-10-11, 12:44 #2Moderator
- Join Date
- Dec 2004
- Madison, WI
Does the table have an autonumber type field (ie. identifier that is automatically incremented.)
The only time I've heard about a table being locked extensively is on tables that don't have an autonumber type field. These types of tables usually require issuing a 'SaveRecord' type of command on the form (depending on how the form is designed).
I always use an autonumber field in all my data tables (regardless if it's an MSAccess, SQL Server or any other backend db table) and have never had to use a 'SaveRecord' type of command on the form or in code.
Last edited by pkstormy; 02-10-11 at 12:47.Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)