访问前端/ Sql后端 - 访问ramdomly需要关闭 [英] Access Front End/Sql Backend - Access ramdomly needs to shut down

问题描述

我在数据库中有大约20个用户，它们具有Access前端和SQL后端。所有用户都在数据库中同时输入数据。大约有一小部分用户将获得

I have about 20 users in a database that has an Access frontend and a SQL backend. All of the users are in the database at the same time entering data. There are about a handful or so of the users that will get the

Microsoft Office Access遇到问题需要关闭。我们对造成的不便很抱歉。

Microsoft Office Access has encountered a problem and needs to close. We are sorry for the inconvenience.

在评论字段中输入大评论时出错。它不会一直发生，只有当他们在备忘录字段中输入一个非常大的评论时才会这样。我们尝试将数据库更新到2007年但是没有用。我们做了修理和紧凑，但也没做。还有其他任何建议吗？

error when they are typing a large comment in the comment field. It doesn''t happen consistently and it''s only when they''re entereing a comment in the memo field that''s very large. We tried updating the database to 2007 but that didn''t work. We did a repair and compact and that didn''t do it either. Any other suggestions?

推荐答案

@stateemk


这是一个单独的前端，由用户共享，还是每个用户在硬盘上都有自己的前端副本？


每次都是少数几个用户？

Linq ; 0）>

它们都使用相同的单个前端。他们的桌面上只有一个快捷方式。


是的，这是少数几个用户。

They all use the same single front end. They just have a shortcut on their desktop.

Yes it is the same handful of users.

首先要做的就是纠正这个问题！每个用户都需要在各自的硬盘驱动器上拥有自己的前端副本。单个前端的多个用户可能遇到各种问题，包括您报告的内容以及时间问题和彻底的损坏。


这个特殊的问题可能是由别的东西引起的，但不管是单独的前端是必须的。执行此操作后，查看问题是否已解决并报告回来。

First thing to do is to correct this! Each user needs their own copy of the front end on their respective hard drives. Multiple users on a single front end can run into all kinds of problems, including what you''re reporting as well as timing problems and outright corruption.

This particular problem may be caused by something else, but separate front ends is a must, regardless. After doing this, see if the problem resolves and report back.

这篇关于访问前端/ Sql后端 - 访问ramdomly需要关闭的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！