Thanks for your help on the last one, I have an Adodc and a datapath (known only at runtime) stored in a string. How can I do this without having to have two sets of the database (one on each machine in app.path) and one on the network somewhere?
I only want one database, and I don't know where it will be until runtime - the Adodc control doesn't like having an empty Connection string - help please!!