I have a VB application that will be accessing an MSAccess database. The database will be on a server and I want to have my application on a number of machines. What is the best way to do this? Should I have my application installed on each of the machines and have each installation establish a connection to the database?

Someone also suggested that I package the database with the VB application and install that on the server, then create shortcuts to the application on each client machine.

What should I do?

Any useful suggestions would be appreciated.

Thanks in advance.

Tesita