- You should be able to put the runtime in the folder of the MDE and xcopy it to another machine and it should work.
Access should have an easy way to resolve Reference problems
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