I have an access database split. It is part of an app working along with an excel add-in.
Within excel, should I address all query updates directly to the back-end version (in the shared network)?
Or should I connect to the front-end (local)?
As I understand splitting access prevents from data corruption in shared database (when users open same file). If I use a SQL command within excel and send it directly to the back-end, then I am using excel as the front-end (and that clears the issue, am I right?)
Many thanks in advance.