Allowing Multiple Connection to project with local Database ? VB

Question

I've just build my first solution of my project that consist of a Local .mdf database & forms. However when i tried to access from different computers in a local network, only one is able to run the project at a time. The others computer failed & displayed a timeout error. I would just like to have an explanation why it happened? Why isn't my .mdf allowing multiple computers to access it?

p.s It works great when only one computer is running/using the project.

Thanks in advance.

You might be interested in using a real SQL-server, which runs as a service on a server to ensure multiple users can connect with ease. — Mr47
– Mr47, Commented Jun 21, 2013 at 12:50
Thanks, i've managed to set up a SQL Server & works fine now . My question is why does it require an SQL server to do the transaction? — user2508982
– user2508982, Commented Jun 24, 2013 at 4:42

Community · Accepted Answer · 2017-05-23 10:32:06Z

1

Just curious is it possible it didnt work because they don't have sql server installed on there machine and the machine therefor doesnt know how to interact with the .mdf file?

Simultaneous or direct access to Database files is a very bad practice or simply impossible.

Use proper DBMS tools to access the data.

And yes - its possible to access Web site project for demo.

srces: Multiple connections on a single .mdf database (ASP.net) SQL Server

answered Jan 23 '12 at 13:20

Oleg Dok 10.2k1521

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Jun 28, 2013 at 16:55

Pakk

8592 gold badges19 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Allowing Multiple Connection to project with local Database ? VB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related