problem accessing database

I'm a new .net programmer and have just built my first application in vb.net. Now it is completed and i want to deploy it on the client machine. the database is to be kept at a central server and the software is installed on each machine. To access the database which is MS Access i've used application.startuppath & the database name. but when i deploy my software it asks for the database to be present in the program files folder as that is the destination folder where my software resides after installation.so what should i do so as to deploy the software,should i give the server name, i'm using ODBC driver. Also my other problem is crystal reports,i've added the required merge modules in the setup nd deployment project that i built to deploy my application. The crystal reports exist as bundled version in vs.net and i've them as embedded resource but in the reports that i've generated, i've added database so that may be the problem as the location of database changes from my machine to clients machine,should i use something like local or server name...please help me,its urgent....