• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

To find an INI file from Access


I have a simple code in my Access DB to get or write to the ini file.
Function GetIniEntrySettings(strSection As String, strEntry As String) As String

    GetIniEntrySettings = GetSetting("Sample", strSection, strEntry, "")
End Function

But I don't know how to find that INI file! How can I locate that INI file?
I didn't create that DB and need to find that ini file. Code doesn't define or declare
any INI files. Is there some settings in the MDB file I can check?
Is there a defualt folder that ini files sit?

So to summarize - how can I find the ini file that my code talks to.
1 Solution
What ini file?  What program?  What version of Access?  What OS?

Most of your default settings, as would be set in Tools, Options, would now be stored in your system registry.  
GetSetting queries the Windows registry, not an INI file.
In Access 2002, ini files are used only on MacOS. I don't know where to look for it, but here are some pointers:

    ? DBEngine.IniPath

This shows the registry path on Windows. Perhaps it will show the path to the ini file on a MacIntosh? You also have:

    ? SysCmd(acSysCmdIniFile)

This could also be a clue. If you are looking for custom ini files, the switch /profile superseded the old /ini switch. But again, is that only Windows?

Finally, it's probably that the function you show is merely a wrapper added when upgrading from Access 97 or earlier. Have you looked into the registry under this key:

HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Sample\...

LenkaLAuthor Commented:
>>GetSetting queries the Windows registry, not an INI file.

That is close to what is happening. I did find those settings in registry on another machine.
How can I copy those settings onto my machine?

When GetSettings runs on my machine it obviously returns nothing.
Is there some script I can write just to copy those settings?
locate the "Sample" key and export it to a *.reg file (only that branch). Copy that file to your computer and double-click it.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now