My users want to start storing data that is appended to a text file by an outside process into a database. The problem is that the location and name of the file is not constant. I setup a linked text file and a couple queries that "key" the data and compare against the data already imported to determine what's new and append it.
Problem is, even though Microshaft says you can set the source file of a linked table in code, it's generating an error. Code and Error follow: