Microsoft Access Charts - Having source from another *.mdb file

Question

So I am trying to create a chart in Microsoft Access. I have my UI in one *.mdb file and my database in another *.mdb file. I am trying to have the chart get its data from the database *.mdb file but it doesn't seem to work. SourceDoc and SourceItem don't seem to respond as I am expecting it to (all examples point to *.xls files) and there isn't an example online out there for something like this. Is it even possible to have the chart get its data from a *.mdb database file?

Answer 1

You could create Linked Tables to the table data sources in the data backend .mdb, and then simply refer to these linked tables as the datasources for your chart.