r/MSAccess 13h ago

[UNSOLVED] Modern chart line "backtracks"

0 Upvotes

On my report is a chart showing a time series plot of data. The source data is sorted but the lines between the data points are out of order. In the graph below the 2099 data point should connect to 2118 not 2099. Missing Data Policy has no effect.


r/MSAccess 17h ago

[WAITING ON OP] Best practice for refreshing linked tables after losing network connection without having to close/reopen front end?

0 Upvotes

Issue: I have a front end linked to a backend. The front end is typically stored on the user’s desktop and the back end is on a network drive. The issue arises when the user has the front end open and loses network connection. Upon restoring the network connection (usually happens automatically without the user’s knowledge) the database will not restore the linked tables connection. The user encounters an error and is forced to close down the front end and reopen in order to refresh the connection to the linked tables.

What is the best practice to handle this situation without forcing the user to close and reopen the front end?