Redian新闻
>
Help for VB 6 and MS Access DB
avatar
Help for VB 6 and MS Access DB# Database - 数据库
m*r
1
I have a problem with my VB program. This program retrieves data from MS
Access Database, after view each record, update it back to the database. The
problem is that it can always update some records but unable to update certain
other records. It always gives me an error "Could not save; Locked by another
user!" But I am very sure I am the only person who is accessing the database.
There is absolutely no other users!
Is this a problem with the program itself or the database? I checked the
progra
avatar
aw
2
it's locked by yourself. check the ado connection lock options, there're quite
a couple.

certain
another
database.

【在 m*******r 的大作中提到】
: I have a problem with my VB program. This program retrieves data from MS
: Access Database, after view each record, update it back to the database. The
: problem is that it can always update some records but unable to update certain
: other records. It always gives me an error "Could not save; Locked by another
: user!" But I am very sure I am the only person who is accessing the database.
: There is absolutely no other users!
: Is this a problem with the program itself or the database? I checked the
: progra

avatar
m*r
3
I use adLockOptimistic, there should not be any problem. ANd why it only
happens to certain records? When I end the program, and restart it, the same
records get locked. SO confused!

quite
The

【在 aw 的大作中提到】
: it's locked by yourself. check the ado connection lock options, there're quite
: a couple.
:
: certain
: another
: database.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。