Connect to Access on different computer

Hi,

I just wondering cause now i'm connecting to MS Access using ADOC which set to specific path.
Once program has been publish I am unable to change that path, so it means that I cannot move
or change my database storage place.
Is there anyway I can set this path during program installation and also be able to change this path?

I have alot of ADOC connections on many forms, so I would like to keep using it. Otherwise, it will
be a pain to go change all of them.

thanks in advance

One suggestion that I would have for something like this, would be to have your ADOC connection strings equal to some value that you could tote along with the published file. That way, if at any time you would need to change the place of the database, you could easily just update the text file. Just make sure that the text file is always in the same place relative to the installed program. I hope this helps!

Provider=Microsoft.Jet.OleDb.4.0;Data Source=\\Computer2Name\Share\database.mdb;

yep, thanks for your help

at least it help the part that it's not hard code into the program.

sorry John but could you please explain a bit on how that line of code will be different from using ADOC?

thanks