Bonjour,
je parle un peu français. mais il fait beaoucoup de temps que je ne practise. S'il n'est pas un problème, je vais parler anglais, mais je peu essaier de dire tout en français si vous n'avez besoin.
So, I think there is no problem to format your report to not show HTML formatting. We can try to make a simple "replace" for the most common tags, or, in the other hand, get HTML code and return plain text with HTMLDocument object. Anyway, the solution can be done in an esay way.
For your second problem, I think a "replica" is not your best solution; create a replica implies that the data updated in one copy of the DB will be syncronized with the other, but it continues working as DAO, not ADO (DAO=1 user, ADO=multiple users with recordset locking). You are not locking recordsets when you edit data, and if a modification is done on same register on both DBs it will generate corrupted data. My solution here rests on "split" the DB: tables, queries and relationships in one DB and UI on the other DB.
Fields in UI DB are linked to the tables in Data DB, so data is the same for the different UIs. With this structure, when you change a record in one UI, it's locked and it cannot be modified with the other DB until changes are commited. It can be done all in access, no need to change the system, and depending on the amount of forms and other UI stuff it can be done relatively fast.
Please let me know your feelings, I can do the job without any delay.
Thanks for reading