这个问题困扰我好久了，如图

yedaoan

我用ODBC链接SQL server，其中有一张老是出现如图的问题，是不是ODBC链接SQL不稳定啊（我的前端是MDB），用ADP不会的，我试了很多办法：

1、SQL服务器重启（不行）

2、客户端重启（也不行）

3、在SQL中删除这张，重新生成（还是不行）

没有办法了！！！！[em06][em06][em06]

Benjamin_luk

database objects by using the Database Splitter Wizard.

Choose a suitable record-locking strategy. If you use optimistic locking (No Locks), Access doesn't lock a record or page until a user saves changes to it, and data might be more readily available as a result. If you use pessimistic locking (Edited Records), Access locks the record as soon as a user begins to edit it <NBSP />— records might be locked for longer periods of time, but users don't have to decide whose changes to save if two users edit the same record simultaneously.

Choose the appropriate locking level strategy (page-level or record-level locking).

Avoid locking conflicts by adjusting Refresh Interval, Update Retry Interval, Number Of Update Retries, and ODBC Refresh Interval settings (if applicable).

Benjamin_luk

可能是记录锁定的问题吧 ， 请按以提示检查一下

yedaoan

终于弄明白了，是有一个字段设成BIT，改成CHAR，就不会了。看来ACCESS还不是很成熟啊！！！