- At the moment when there is a bad reference you get an unhelpful error message: “Compile Error Can’t find project or library” and the code will break on a line containing the LEFT function.
Linking Tables to XML Files
Microsoft Access should support the ability to use an XML file as a linked table, just like it supports linking a table to a SQL backend.
Further, if they include an XML parser it would be easy to implement a web service linked table.
For example, a supplier may publish their price list as a DataSet returned from a WebService. By entering the path to the WebService then selecting the function, Access could then import this as a linked table.
Figure: Access supports links to many data sources, but not XML