INI file perhaps?

[Mark]

All,
there has recently been a re-structure of out network drive at work
which has highlighted quite a few flaws in my coding. I am no expert but am
learning as I go. Throughout the code within the database, there are many
references to network folders and files. I have had to go through all the
code to updates these values to reflect the recent change.

I was hoping that somehow, I could create a text file with these paths
listed. This way, I would only have to ammend the text file rather than
ploughing through pages of code.

Could anyone offer any advice on the best way to do this???

TIA,

Mark

[Larry Linson]

You can certainly save settings in an INI file. You can also save them in
the Registry. You could save them in a text file, or you could store them in
a table in the database itself.

And, if you didn't realize it, there is some reliable, well-tested code for
using Windows APIs at http://www.mvps.org/access -- a site which is a superb
source of Access information. One that I use often... not in every database
I create, but in many: is the API001 entry on using the Windows Common
Dialog from VB/VBA code to let the user browse for a file.

I can't remember if there are examples of the "ProfileString" and
"PrivateProfileString" APIs for dealing with INIs. There are native VBA
commands/builtin functions for writing to and retrieving from the Registry.

Larry Linson
Microsoft Access MVP
"Mark" <ma*********@ntlworld.com> wrote in message
news:ua****************@newsfe2-win.ntli.net...

All,
there has recently been a re-structure of out network drive at work
which has highlighted quite a few flaws in my coding. I am no expert but
am learning as I go. Throughout the code within the database, there are
many references to network folders and files. I have had to go through all
the code to updates these values to reflect the recent change.

I was hoping that somehow, I could create a text file with these paths
listed. This way, I would only have to ammend the text file rather than
ploughing through pages of code.

Could anyone offer any advice on the best way to do this???

TIA,

Mark

[Tom van Stiphout]

On Wed, 25 Jan 2006 08:07:01 GMT, "Larry Linson"
<bo*****@localhost.not> wrote:

The VBA functions are GetSetting and SaveSetting.
-Tom.
<clip>

I can't remember if there are examples of the "ProfileString" and
"PrivateProfileString" APIs for dealing with INIs. There are native VBA
commands/builtin functions for writing to and retrieving from the Registry.

<clip>