I am using MS Access 2016. I have a project which in part creates and moves folders around. I am currently using Application.CurrentPath & [form control value] & "\" (etc.) to store the created folders (and to move them when users are done). When I deploy I want to split the db so I can work on the front-end without disturbing users, and so that multiple users can work simultaneously. The back-end will be stored at a shared network location. Users will get a copy of the front-end on their PC to speed things up.
If I do it this way, the folders that the solution creates will be created in the same directory as the users' front-end (no bueno.)
Should I change the code to be hard-coded to some network location (which means moving it is a pain) or change the code to refer to the back-end location? If I refer to the back-end location, what does that code look like?
Many thanks in advance!
