Access or MS SQL 2k ?

[kr80]

I have a application with Access as a backend, and vb.net on the front end.

The Db file used to reside on only one machine. Now to make it multi user usable through a network I split the Access file and used the distributed file access method to share it. But the problem i am facing now is not all users have the same path to that shared drive.
How does one solve this problem, do i have to migrate to a MS SQL server ?

Thanks,
Karl

 

[jmcilhinney]

Each of your clients can have a different connection string, depending on where it is stored. Access isn't really the best choice in a multi-user environment though.

 

[kulrom]

As long as you have less than 10 clients for shared MS Access DB access you should not worry
about the path, It is easy to make a connection string yourself (usually it is stored within module). Just take care to enter same address or name of the server machine where DB is located on for all clients.

Cheers

 

[kr80]

Thanks for the fast reply.

-karl