Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
VBA application hangs up at a certain point

Do i need to change the recordset type and the type of lock ..can this solve the issue
Set cnn = CurrentProject.Connection
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseClient
rst.Open strSQL, cnn, adOpenKeyset, adLockOptimistic
Let me know what the issue could be... would greatly appreciate your efforts
thanks
rds
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)
So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)