Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted
Updated 22-Feb-16 5:37am
v2
Comments
Richard MacCutchan 19-Feb-16 11:44am    
I've tried a million things
Most unlikely.

Given that it only works with your login, you need to identify what is different between that and your potential users.
colemauro 19-Feb-16 11:53am    
Besided myself having Visual Studio and others not, i see no difference.
I've tried in computers with Windows 7, Windows 8, with/without Access installed, and nothing.

And since the error only appears in the costumers, i can't see what is causing it.

Durint my several attempts, i got to receive some more familiar errors like:

Downloading file:///O:/T_AIM/01 - Concepts/11 - CFA/15 - UACT/Application Files/AIM-UAC-BrgP_1_0_0_8/Application Files/AIM-UAC-BrgP_1_0_0_8/AIM-UAC-BrgP.exe.manifest did not succeed.
+ Could not find file 'O:\T_AIM\01 - Concepts\11 - CFA\15 - UACT\Application Files\AIM-UAC-BrgP_1_0_0_8\Application Files\AIM-UAC-BrgP_1_0_0_8\AIM-UAC-BrgP.exe.manifest'.

It seams Setup.exe can't download manifest. But again, during by latest attempts this kind of error log, stopped coming from the costumer.

As i said before, i'm a complete novice when it comes to publish projects like this
CHill60 19-Feb-16 12:29pm    
Have a look at Sysinternals Suite[^] you might be able to find out what is happening.
Ask for a testing ID to be set up that is modelled on your customer's profile then you can test without bothering your colleagues. Or set up a virtual PC e.g. Hyper-V WMI provider (V2) (Windows)[^]
Have you looked at the Event Log on the user machines? Have you considered writing to it? Introduction to the EventLog Component[^]
Foothill 19-Feb-16 14:51pm    
If you do a straight copy and paste of the .exe, does the program still crash on launch? Is your program writing to the registry?
Dave Kreskowiak 19-Feb-16 15:02pm    
Deploy the Debug version of the app and you'll get more information.

Look in the Application Eventlog in EVENTVWR and you'll probably find a more descriptive error message. Without that, everyone is just guessing at the possible causes, and there's a LOT of them.

1 solution

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.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900