CODEWITHSUNDEEP
ms-accessvb6
Ankan
Ankan

Reputation: 15

creating a server project in vb6 and ms-access

i am making a project in visual basic 6 and ms-access. Its about college management system and is a server based application. Clients can access the system in the server. But the main problem is how can i make my client use the access file located in the server computer.?? if my database file is already opened in the server computer then my clients cannot access the file in the server. Is there any another way to resolve the problem?

How can i make a database file in access so that all my clients can use it simultaneously? Please help...

Upvotes: 1

Views: 1273

Answers (2)

AnthonyWJones
AnthonyWJones

Reputation: 189437

I can't see any reason why clients on other computers can't open the same access database at the same time. What makes you think they can't? Can you provide more details on the problem?

That said are really sure you want be using MS Access as the DB? Why not simply use SQL Server 2008 Express? You can use either the SQL 2008 management tools to administer this DB or you can use MS Access connected to the SQL 2008 Express engine. This approach will definitely be considerable more stable and significantly faster.

Edit:

To answer your question more specifically it is possible to open an Access database exclusively which would result in your problem. Are you using ADO? What is your connection string?

Upvotes: 1

Traveling Tech Guy
Traveling Tech Guy

Reputation: 27811

I believe you'll find your answer here. Quoting from the MSDN article:

To prevent this behavior, you must make sure that all users who open the database have read, write, and create rights for the folder in which the database is located.

Additionally, if you are using a security-enhanced Access database, you must make sure that the users who open the database also have Read permission and Write permission on the folder that contains the workgroup information (.mdw) file.

Upvotes: 3

Related Questions