Connect to Access 2000 Database Remotely

I have created a VB application that connects to an Access 2000 database. I am user DEConnection to communcate with the database. When I run the applicate in the VB IDE it works fine, however when I package the application to run it I am having all kinds of problems. The only way I can get the packaged application to communicate with the database is to use Microsoft.Jet.OLEDB.4.0. However it requires inputing the connection source or the path to the database everytime the application is run. Furthermore, I can connect to the database with tha application remotely but if I try to save anything I get a error. Is there another way to package my application without 1) Predefining where the database is located
2) Is there a way to have my application prompt for a database source setting once and not ask for it everytime the application starts
3) Lastly connect to this Access database remotely over a network.