[AccessD] Read External File for Path String

Gustav Brock Gustav at cactus.dk
Fri Jan 20 05:47:14 CST 2006


Hi Stuart

Use A2002+.
Have an internal table with your path, tblPath.

To export:
Application.ExportXML acExportTable , "tblPath", "c:\mypath.xml"

To import:
CurrentDb.Execute "Delete * From tblPath"
Application.ImportXML "c:\mypath.xml", acAppendData

To read:
strPath = DLookup("Path", "tblPath")

Not quite sure how "easy" that is, though in total only four code lines net are needed.
However, if you need to store a bunch of user or app settings it might be a nice method with all the advantages of XML storage and exchange possibilities.

/gustav

>>> stuart at lexacorp.com.pg 20-01-2006 00:48 >>>
On 19 Jan 2006 at 15:00, Charlotte Foust wrote:

> Actually, the XML files wind up with a structure very similar to the ini
> files but you don't need API calls to read them.

So how  would you create, then read an XML file to store a backend server 
path?
-- 
Stuart





More information about the AccessD mailing list