Sign-in

Sign-out

Last

Next

QUESTION

REPLY

ASK

RECENT

Login

JOb

Forum Policy

Read:

Hide:

Show

Please input correctly

You are logined,Please click reply OR ask tag,USER_ID:

Server is busy or in error, if still in problem, please send us email at support@

HKSTOCK

Below area will not be traslated by Google,you can input code or other languages
paste code or other language below=>click Code(Run code, select all=>click STEP icon=>click Code)

Current Browser:

Update your Chrome/Edge to >=130.0.0.0 version
to get faster future/News data: Install/Update Chrome

新聞財經娛樂♬資訊 News Economy

About Us|Service|Pricing

HKSTOCK
QUESTION

REPLY
ASK
RECENT
Login
Online Help
Job
Forum Policy
WeTalk New

Stock Index全球即時指數期貨:

牛熊資金流恒指期貨港股升跌百家樂

Google Ads will be resumed after 02:15:00

&nbps;

Just click Google Logo to log-in 1-account for:
→ Ask/Reply Question with GPT A.I. Model Library
→ Online Chatroom/Game/Good Music/Movie-Sharing

→ Video Wetalk here with your friend/colleague/family
→ Real-time:Break News/Stock Future/OBV/Chart Data

This area is developing message box

News即時新聞:↓

更新

News即時新聞:↑

更新

On Balance Volume (OBV):

Option:

Youtube Video♬ Sharing by members:↓

1

Youtube Video♬ Sharing by members:↑

1

Ask Question Forum:

Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page

C

O

M

P

U

T

E

R

2

8

Show

#

ASK RECENT

Title: max 200 characters

Topic/Tag: max 100 characters with ";" seperator

←

Files To Upload

Status:

Size
Underline
Bold
Italic
Indent
Step
Bullet
Quote
Cut
Copy
Paste
Table
Spelling
Find & Replace
Undo
Redo
Link
Attach
Clear
Color
Code

Below area will not be traslated by Google,you can input code or other languages

Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).

X-position of the mouse cursor

Y-position of the mouse cursor

Testcursor

caretPos

Attachment:===

VBA application hangs up at a certain point

Asked by Radhs74

at 2024-06-14 11:13:32

Modify

Point:500 Replies:25 POST_ID:828341USER_ID:11140

Topic:

Microsoft Access Database;;SQL Server 2008

The VBA application hangs up at this point of line ..(bold,underline and italic) and I got to explicitly kill the session
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

Author: Radhs74 replied at 2024-06-30 13:04:27

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-30 13:02:17

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: Torrwin replied at 2024-06-15 13:01:01

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-15 12:20:32

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: Torrwin replied at 2024-06-15 11:54:34

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-15 09:53:44

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: Torrwin replied at 2024-06-15 09:42:18

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: Torrwin replied at 2024-06-15 09:40:14

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-15 09:07:23

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-15 08:38:15

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: Torrwin replied at 2024-06-15 06:33:06

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-14 16:06:26

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: Torrwin replied at 2024-06-14 14:44:09

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-14 13:48:22

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-14 12:52:30

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: Torrwin replied at 2024-06-14 12:46:21

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-14 12:44:10

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: Torrwin replied at 2024-06-14 12:41:42

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-14 12:40:02

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Accepted Solution

Expert: duncanb7 replied at 2024-06-14 11:58:09

500 points GOOD

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: Torrwin replied at 2024-06-14 11:50:51

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: duncanb7 replied at 2024-06-14 11:49:20

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: duncanb7 replied at 2024-06-14 11:39:48

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Author: Radhs74 replied at 2024-06-14 11:31:52

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

Expert: duncanb7 replied at 2024-06-14 11:25:16

So we've ruled out connectivity and security...are there any transactions going on against the database? (in yours or another application)

sidebarimg

Your Information

USER_ID:
Name:
Email:
Location:
Region:
City:
IP: 216.73.216.72
Timezone:
Browser:
Version:
Cookie:
Platform:
Language:
User-Agent:
latitude:

Members/Profolio

Please Login

Privacy Policy私隱政策

免責聲明：以上資料僅作參考之用
computer28.com對以上資訊的準性和可靠性不能亦不會作
任何保證或承擔，並對資料或有關的錯漏或延誤而作出的任何
決定或導致的損失概不負責.
Disclaimer: The above information is for reference only,
computer28.com cannot and will not provide any guarantee or
commitment for, and not responsible for any decision or loss
caused by the information or related errors,omissions or delays.

2011-2026 www.wetalk28.com video conference RoomID | Powered by www.computer28.com

↑Top