CODEWITHSUNDEEP
vb.net
Norhisham Ya
Norhisham Ya

Reputation: 11

Run program with database access from Windows Server for concurrent users

My compiled VB.NET program is stored on Windows Server 2016. This program will call a database (.mdb) which is also located on server.

I have created user account with password clients (user) to access and run this program through share folder.

My problem is, this program only can be run by only one user at a time due to database lock for current user. There is any way to make it so that this program can be run by multiple users at the same time?

Upvotes: 1

Views: 48

Answers (1)

Danny
Danny

Reputation: 191

I never heared of Windows Server 2017. Perhaps you mean Sql Server 2017? You should/could use a database like SQL Server, Mysql or Postgresql instead of Microsoft Access making multiple user much easier.

See Is there a downside to using Access as a database? for a bit more information.

Upvotes: 1

Related Questions