So I have been looking around and i really do not think this is possible but I thought I would ask the community just to see if it is possible.
Imagine you have a split database with two users making reports on their own front end. Lets say user 1 wants to share a report they built with user 2. is it possible to send this Object through vba so that user 2 would received a working editable copy that they can use on their front end without sharing the actual accdb front ends?
I thought about creating a Database that would just host the reports but again if I cannot send or access secondary database objects then this method would not work.
What is your thoughts on the concept and do you think it is possible.