Specifiying a connection string in ms access forms

[thebionicredneck2003]

Hi guys,

I have a question about connection strings. Basically I have an access front end and an access back end. It works fine for now, but when it gets rolled out, I don't want to have to manually relink the tables every time. Is it possible to hard-code the database connection strings for all the tables used in the solution as the paths won't change once deployed?

Please note, I am a newbie and I know next to nothing about vba. I have seen lots of samples of code concerning issues similar to this, but I don't know where exactly to put the code in, so some simple guidance for an access newcomer on this would be appreciated.




Many thanks

[June7]

Code can relink the tables. Where are you 'rolling out' to? Just your internal network server? Here is how I manage split database: http://forums.aspfree.com/microsoft-...ue-323364.html

[thebionicredneck2003]

Thanks for this. It looks like it will do what I need it to do.

I have split the database into front end and back end and will be saving the back end on a network share and will circulate a front end version to the various users.

In your link you said "Run this procedure in master copy of the frontend before it is copied to users"

When you say run, what exactly do you mean? Do I have to put it in like an event or something? I apologise once again, as I am really asking noob questions, but I just want to be perfectly sure I am doing the right thing.


Many thanks again

[June7]

The procedure sits in a general module I call Utilities. I manually run it when needed (not very often any more). I just put cursor anywhere in the procedure and click Run from the menu.

[thebionicredneck2003]

Wow!!! June7 you are a genius. Thank you for your help and for your clear explanation on where to put the code.

It works as expected. Very happy now