Visual Studio 2013 +访问数据库将无法在其他计算机上运行 [英] Visual studio 2013 + access database won't work in other computers

问题描述

大家好，



Windows 8 64位

Visual Studio 2013 Express Edition

Office 2013，Access 32位

数据库：MS Access



所以我正在编写一个程序供一些人使用我公司的用户。

由于我无法使用服务器（和MySQL一起使用），我决定使用Access作为存储在共享文件夹中的数据库。



过去几周我一直在努力工作，而且我大约70％。



问题：

此程序可以在我的电脑或任何其他计算机上找到我的登录信息，但不能与任何其他电脑一起使用用户/计算机。



我使用VS的发布功能，然后客户运行安装所有内容的Setup.exe，并在用户桌面上创建快捷方式。



当他们双击这个快捷方式时，总是相同的......程序停止工作。



1我在这里离开了我的联盟，所以有一百万件我不知道的事情。

2.因为这可以在我的电脑上运行，所以要做任何测试我必须去一个我的同事电脑，并测试。这当然没有好处。我不想从他们那里花时间。



授予：其他用户对文件夹的写入访问是我存储了数据库。



任何建议：



a）解决问题本身

b）修复它



提前致谢。



我的尝试：



我试图在另一台计算机上运行这个exe文件，使用Windows 7，我的登录没有安装VS，然后再找到它。

我用发布设置尝试了一百万件事，但我只是不知道导致错误的原因。它只适用于我的用户

解决方案

你好，



它接缝是一个访问权限问题。

如果我从debug / x86文件夹中复制exe / config / manifest，他们可以访问数据库。

如果我发布它，并将其安装在客户计算机上，我收到错误消息，因为它试图从我的C盘下载文件。所以这是我必须要检查的东西。



所以至少知道它有效。我还是要看看当多个用户（更多的是20个）同时访问数据库时会发生什么。



感谢您的反馈。

Hi guys,

Windows 8 64bits
Visual Studio 2013 Express Edition
Office 2013 with Access 32 bits
Database: MS Access

So i'm working on a programe to be used by some users in my company.
Since i couldn't use a server (and MySQL with it), i decided to use Access as database that is stored in a shared folder.

I've been working on it hard for the last weeks, and i'm about 70%.

Problem:
This program works find in my computer or in any other computer with my login, but won't work with any other user/computer.

I used publish function of VS, and then costumers run Setup.exe who installs everything, and creates a shortcut in user's desktop.

When they double click this shortcut, always the same s... "The program stopped working".

1. I'm way out my league here, so there are a million things i don't know of.
2. Since this works on my computer, to do any testing i have to go to one my colleagues computer, and test. This is of course no good. I don't want to take time from them.

Granted: Other users have write accesses to the folder were i have the database stored.

Any suggestions on:

a) getting to the problem itself
b) fix it

Thanks in advance.

What I have tried:

I've tried to run this exe file in another computer, with Windows 7, no VS installed with my login and again, it works find.
I've tried a million things with publish settings, but i just don't know what is causing the error. It will only work with my user

解决方案

Hello,

It seams it was a access righs issue.
If i copy the exe/config/manifest from debug/x86 folder, they can access the database.
If i publisch it, and install it on the costumers computer, i receive error messages, because it tries to download files from my C drive. So that's something i have to check.

So at least know it works. I still have to see what will happen when multiple users (more less 20) are accessing the database at the same time.

Thank you for your feedback.

这篇关于Visual Studio 2013 +访问数据库将无法在其他计算机上运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！