Question

我的微软准入2007年冻结在我身上。这700个问题吗?

Yes, it s on a network, but only 2-3 people are accessing the backend at a time.

我曾尝试过紧凑和修理,也尝试了。没有工作。

Answer 1

根据我的经验,我可以向您保证,多达15名 working辛地工作的人应当被罚款,而不会明显冻结。

You can explore the following:

How big is your MDB? if it is too big consider splitting it to smaller parts and put all your historical and rarely accessed data into the separate file -- you can easily re-bind all the table in front-end to multiple back-end files.
Check your queries and VBA code. Use optimistic locks everywhere you can and avoid locking tables for reading purposes!
Check your network connectivity and hard drive throughput? Is your serving trying to perform a virus scan every time you update your MDB? Maybe an update is running?
If nothing helps -- try to install MS SQL Express, quickly upsize your tables and re-bind those to your front-end using ODBC connection -- you won t need to re-write your queries (as long as those are written in agnostic SQL, without DISTINCTROW etc).

Answer 2

它像一个锁定问题一样。喷气发动机并不是为多用户使用设计的,根本无法处理。你们应考虑升级为KQ服务器,因为服务器处理得更好。服务器的快式版本是免费的,而MS Access有一个不断升级的izar子,将做你们的所有辛勤工作。