Can't connect to mdb on some computers

[udigold1]

Hi,



I have written c# WinForm application based on an Access DB. Both App and DB are located on a server.
For some reason, there are several stations that can't connect to DB (When the app try to load data to a dataset it says it cannot find table 0).

I don't why it happens, because those stations have the same security permissions (granted through the 'security' tab of the folder) like the stations that do work.

Any suggestions?

Thanks,
Udi G.

[ssanfu]

If I understand correctly, you have data in tables in an Access dB (the BE) that is located on a server. And you have a C# app (the FE) also located on the server.

This is not the normal (usual) set up. The data in the BE on the server is correct.

But EACH user should have a copy of the FE (C# app) on their local computer, linked to the BE. Each user also needs the correct permissions - usually read/write. Having everyone use the same FE WILL cause corruption at some point. This is especially important in a multi-user environment.

(This would be my first step in fixing the problem)

----------------------------------------------------
FE = Front end, ie the forms, queries, reports and code
BE = Back end, the tables. The place where the data is stored.