Deployment with MSAccess Locally Stored

Question

I created an application that uses an Access.mdb file to store information. When I created the connection to this database, the filepath was set to the bin folder in my solution folder. When i add a Deployment Project to my program and build the project, ive added the Access.mdb file to the application folder, but the path is still set to the bin folder on my local workstation.... Is there any way to set the paths to the Application Folder at build time, or do i have to change the path prior to deploying?.... Please?