[AccessD] Read External File for Path String

On 20 Jan 2006 at 12:47, Gustav Brock wrote:

> 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.
> 

You generally don't need to exchange user/app settings between 
applications.

If you have to store you settings in a table in the database to use an XML 
file, why bother? You can just read/write to the table itself.


 -- 
Stuart