I have a setup where I have a database front-end with another database which is the backend. All forms and VBA are stored in the front-end and the data is stored in the backend (pretty standard).
The client requested that I take the backend and "split" it into 2 seperate backends, as there...