By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,995 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

INI file perhaps?

P: n/a
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
Jan 25 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jan 25 '06 #2

P: n/a
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>

Jan 25 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.