I have created a bunch of reports which have queries and tables from an access mdb file.

The proble I have is that the database is going to be on a server on a LAN.

Is there a way I can at runtime, find the location of the database and then use that as the source.

Thanks In Advance