Ok well I am using crystal reports and I have tried linking a crystal report to a table in an access database manually which works on my pc, the problem is that when I release the app, the database is unlikely to be in the same location on the users pc.

So how do I programmatically set the path of the database used by the crystal report?