是否需要在主机上安装Access才能使用Access MDB数据库? [英] Does access needs to be installed in a host computer to use an access mdb database?

问题描述

我创建了一个小型应用程序，该应用程序尝试连接到网络设备并在连接成功或失败的情况下更新访问数据库.但是，它不起作用，并显示一条错误消息，指出数据库已锁定.只有一个其他应用程序不断从数据库中读取数据.但这不应该影响更新过程吗?另外，运行应用程序的主机没有Microsoft访问权限.问题的原因是什么?

解决方案

如果您有另一个进程正在读取数据库，那么可以，您的文件将被锁定.

如果您在任何计算机上的Access中打开了该数据库，则该数据库将被锁定，并且无法更新它.您必须关闭Access才能使用数据库.

Hi,
I''ve created a small application that tries to connect to a network device and update an access database if the connection was successful or unsuccessful. However, it doesn''t work and gives an error message saying that the database is locked. There''s only one other application that constantly reads from the database. But it should not affect the update process right? Also, the host machine where the application is running does not have microsoft access. What''s the cause of the problem?

解决方案

If you''ve got another process reading the DB, then yes, your file will be locked.

If you have that database open in Access on any machine that database will be locked and you can''t update it. You have to close Access before the database will be available.

这篇关于是否需要在主机上安装Access才能使用Access MDB数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！