M
mscertified
Referring to http://support.microsoft.com/kb/300216 in the paragraph headed
'Minimize the number of connections made from each client'. Does anyone know
more about this? I appear to have hit the problem mentioned in 'by default
there is a 5-second delay between writing a value to the database and being
able to read this updated value when writing and reading using 2 different
Jet connections'. Does anyone know what constitutes a 'jet connection'. For
instance if I refer to 'CurrentProject.Connection' in one procedure and then
again in another procedure, is that 2 diffreent Jet connections? Also, does
this mean that is one user makes a database update it will take 5 seconds
before another user can see it?
'Minimize the number of connections made from each client'. Does anyone know
more about this? I appear to have hit the problem mentioned in 'by default
there is a 5-second delay between writing a value to the database and being
able to read this updated value when writing and reading using 2 different
Jet connections'. Does anyone know what constitutes a 'jet connection'. For
instance if I refer to 'CurrentProject.Connection' in one procedure and then
again in another procedure, is that 2 diffreent Jet connections? Also, does
this mean that is one user makes a database update it will take 5 seconds
before another user can see it?