Access Database throw "Disk or Network error" when running in server

Question

Firstly I looked up every OleDbException "Disk or network error" topics but nothing solved my problem. Im developing a program for my office on Windows Forms and using access database. When I test the program in local everything is fine(db is in the local computer). But when I moved up the database into the shared folder (office server) , its starting to throw Disk or Network Error while connecting to db(not every connection).

I can read user table data (it means select command working)
But i cant read hours table data (but sth is wrong)
I can add new hours to table (insert command working)
But i cant add a new user (sth is wrong as well)

Connection String:

OleDbConnection db = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\Ug_Filesrv\Ug_Proje$\0140_SAU_CAE_Library\FOKS Database\FOKS_Database.mdb;Jet OLEDB:Database Password=123456;");

Error İmage

Note: I cant change the database type , only access Database allowed.

Any help needed. Thank you.

Source is "\UG_Filesrv" sure thats not "\\UG_Filesrv" .. using access over UNCs probably isnt the best idea. — BugFinder
– BugFinder, Commented Jun 12, 2018 at 8:34
is this database shared with multiple users? If so its most likely multiple users accessing it at the same time as this is only a file on disk when you write to it it gets locked for other users. — Rafal
– Rafal, Commented Jun 12, 2018 at 8:36
Have you tried adding <identity impersonate="true" username="user" password="password" /> in your web.config? — Dungeon
– Dungeon, Commented Jun 12, 2018 at 8:37
1-) yeah its \\UG ... (miss-copy), I understand but have to use Access :( BugFinder — talhaoz
– talhaoz, Commented Jun 12, 2018 at 11:06
2-) yeah its shared for multiple users , and also Im the only one who is using the system for now , but thank you . Rafal — talhaoz
– talhaoz, Commented Jun 12, 2018 at 11:07

talhaoz · Accepted Answer · 2018-06-12 14:09:29Z

0

Solved !!!

Have you tried adding

<identity impersonate="true" username="user" password="password" />

in your web.config? By Dungeon

answered Jun 12, 2018 at 14:09

talhaoz

3671 gold badge4 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thomas Ayoub Over a year ago

You should ask OP to make it an answer

Collectives™ on Stack Overflow

Access Database throw "Disk or Network error" when running in server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related