Point to Back-End using an INI file

[Quintios]

I split my database and will be rolling it out soon. Each DB will have a front end installed on a user's machine and the back end will be stored in a as-yet-to-be-defined place on a file server somewhere. (The db will never get very big (<20 MB) so I'm not worried about it being a file server.)

The question is, how can I make it such that whenever a user opens the front end, the front end checks a text file to find the location of the back end?

(I'm not worried about security or stealing or anything like that. Security will be set up by the directory permissions on the server.)

There is an existing Access 95 (was that 2.0?) application that does this, but upon first examination it's very very ugly and disorganized and I really don't relish the thought of piecing through the code. I just wanted to post the question to see if I could get a concise straightforward answer in the forums.

Thanks in advance for your help!
Onwards,

Q-

 

[Nassu]

I have used such approach many years in various applications (in Access'95, Access'97 and Access'2000). Requiremet is that in the same directory as front-end database locates, should locate a ini-file which have same name as front-end database but .ini extension.
In ini-file should be at least one line - CONNECTPATH with path and name of backend database (usually in server machine).
In startup I start automatically one so called version-logo form to show application version and relink all existing tables in backend (according to path contained in ini-file). Then the form closes itself. If ini-file does not exists You can select database through the standard Windows openfail popup.
This form and module have developed years ago in Access'95 and probably not very nice from programmer viewpoint (for linking I have used an sample program downloaded from an forum - don't remember which one). But it have worked with acces 95, 97, 2000 and I have avoided changing of code - IT WORKS.

I can separate this form and two or three needed modules to template database and send You. In this case contact me offline at address nassu@hansa.ee

 

[Quintios]

I wrote you to your private email this morning. If you didn't get it please post again so I can write again, or send a note to quintios@yahoo.com

Thanks!!
Onwards,

Q-

 

[gusbrunston]

Hi:
I'm very interested in this topic. Please post all replies publicly.
Thanks. Gus Brunston An old PICKer, using Access2000. I manage

http://www.rentdex.com.

Suggestions welcome. padregus@attbi.com

 

[Quintios]

I have some code with comments written in Estonian. Pretty cool. After I work through it I'll post a FAQ or something.
Onwards,

Q-

 

[Nassu]

Comments are really mostly in Estonian - I programming in VBA and Access mostly for fun, so I did not planned to publish this solution. This solution I created for my friend, who using it.
As You noticed - links refreshing module is written by Shamil Salakhetdinov, from Russia - i found this piece of code from his excellent website years ago.

I am not very frequent visitor of forum, so I noticed only today, that there are option to create FAQ and attach file to this FAQ.
If You are ready to do this it is nice. But if Yoou prefere, that I do the FAQ, I can do it either.

 

[Quintios]

I'm having some trouble with the code. Let me get back to you.

Thanks!
Onwards,

Q-