网络上的Access数据库无法通过快捷方式或资源管理器打开 [英] Access databases on network won't open via shortcuts or explorer

问题描述

我们的网络服务器上的策略设置阻止我们使用快捷方式打开MS Access数据库文件或从Windows资源管理器中双击它们。 MS Access无法启动，不显示任何错误消息，似乎什么也没发生。首先启动
MS Access然后打开mdb文件正常工作。

资源管理器中mdb文件的关联是正确的，此问题仅发生在一个特定服务器上，而不是其他服务器上。使用MS Access 2007运行Windows 7.

解决方案

我们的网络服务器上的策略设置阻止我们使用快捷方式打开MS Access数据库文件或从Windows资源管理器中双击它们。 MS Access无法启动，不显示任何错误消息，似乎什么也没发生。首先启动
MS Access然后打开mdb文件正常工作。

资源管理器中mdb文件的关联是正确的，此问题仅发生在一个特定服务器上，而不是其他服务器上。使用MS Access 2007运行Windows 7.

将数据库拆分为前端和后端的表单，查询是一种普遍接受的最佳实践，报告和代码驻留在前端，后端的数据驻留在后端。这样，前端在用户的计算机上本地运行，并将
连接到服务器上运行的后端。

您是否能够启动Access然后从其中打开文件

A policy setting on our network server is preventing us from opening MS Access database files with shortcuts or by double-clicking them from windows explorer. MS Access does not start, no error message is displayed, and nothing seems to happen. Launching MS Access first and then opening the mdb file works correctly.

Associations for mdb files in explorer are correct, and this problem only occurs on one specific server, but not others. Running Windows 7 with MS Access 2007.

解决方案

A policy setting on our network server is preventing us from opening MS Access database files with shortcuts or by double-clicking them from windows explorer. MS Access does not start, no error message is displayed, and nothing seems to happen. Launching MS Access first and then opening the mdb file works correctly.

Associations for mdb files in explorer are correct, and this problem only occurs on one specific server, but not others. Running Windows 7 with MS Access 2007.

It is a commonly accepted best practice that databases be split into a front end and back end where the forms, queries, reports and code reside in the Front End and the data in the back end. With that, the Front End runs locally on user's machines and connect to the backend running on the server.

Are you able to start Access and then open the file from within it?

这篇关于网络上的Access数据库无法通过快捷方式或资源管理器打开的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！