Microsoft Access Charts - having a source from another * .mdb file

Question

So, I'm trying to create a chart in Microsoft Access. I have a user interface in one * .mdb file and my database in another * .mdb file. I am trying to make the chart get its data from the * .mdb database file, but it does not work. SourceDoc and SourceItem do not seem to react as I expect (all examples point to * .xls files), and there is no such example on the Internet for anything like that. Is it even possible for a chart to get its data from a * .mdb database file?

Answer 1

You can create Linked Tables with table data sources in the .mdb data backend, and then simply reference these linked tables as data sources for your chart.