Q:

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... 

A:

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.

