Splitting Database in mde and mdb for Creating Dynamically Reports

[bestbefore99]

Hello folks.
I need to create dynamically reports using VBA COde in a database. At the same time I want to protect the work done, by giving away an mde Version.

However when using the CopyObject or Creating report at run time, I get an error saying that in mde you cant' create reports, etc..

Theerefore I am now thinking, but please advise if you have better ideas, to spli the database in one withourt the report part, that will be made an mde, and another one, containing only the report functionality.

Still I may have problems when connecting the two.
Can I say to the mdb database that the source for the record is a Query on the mde Database?

And how do I automate the printing ?

Thanks a lot
AccessMax