Deployment- Storing Application Settings

[theDBguy]

True ... but if (like @AngelSpeaks) you move the FE only, it will not normally break the links to the BE
Even so, it is safer to use a UNC path than a relative path

Oh, sorry, I misinterpreted @AngelSpeaks' earlier post.

So I did some more research, and on this forum, I found a post that stated that if both FE and BE were in the same folder, they don't have to be relinked (which I tested to be true).

Then I moved the FE to another folder and it also worked OK.

I guess I got caught up with the part in bold above and only concentrated on that.

Thanks for the clarification!

 

[AngelSpeaks]

Hmm, that could be misleading. You could be right, but I am not quite sure about it. I would think if the "file path" is the same (not just the folder name), then a relink is not necessary. Are you sure you're not using any auto-relink code? Just curious...

I don't know what auto relink code is.

 

[theDBguy]

I don't know what auto relink code is.

Hi. I think you can disregard that. I misunderstood what you said about as long as the FE and BE are in the same folder, then a relink is not necessary.

 

[isladogs]

Hi Pat
Yes I mentioned using UNC earlier.
I agree with your comments but in fairness to whoever wrote the comment you quoted, one method of setting up the linked BE is to temporarily install the FE in the same folder on the network as the BE. The FE will look in that folder by default and the links can be setup correctly.
Having done that the FE is removed & copied onto individual users' workstations - the links should still work.

Having said all that, I don't use that method personally. Instead I normally use DSN-less connections with connection info stored in 2 local tables

 

[AngelSpeaks]

What is UNC? I was hoping to have a setup program that would handle everything. For now, one user. So i thought installing both in the same folder and either move the FE or copy the FE to another location. I am working on a procedure where the table names are stored in a table in the FE and query and loop through and run the link command ( what the command is, i need to lookup). I am certainly open to suggestions. Thanks