For me, the most secure way to protect the "Side end" would be to have it in a location protected by the operating system. Microsoft has spent a lot more on security than you ever will, so let them secure the file location.
Then you only need to let the person generating the data and the...
If this is happening on TWO machines, what is different with these TWO machines?
Last time I had to debug an issue like this, the user had changed the number of colors they were using then wondered why images looked strange.
So you have "UnitID" and "Unit" as parent. Will you be responsible for tracking tenant information also? If so, I'd highly recommend tenant information being a child record as tenants come and go frequently and often change between units more than you'd expect.
For each appliance, do you need...
In case the previous solutions don't work, you can also use DSum to return the values you need.
DHookom's solution is the most versatile as it will also allow you to filter your report to skip parent records that you are not interested in. Think "Omit all customers who do not have an...
IF you do decide to export to an intermediate database, just remember you can do a LOT of pre-formatting with the export query.
For the casino software, we built up consolidated results for some of it. Think "Instead of submitting what each player made on a per-game basis, sum it up by game...
In your application, will adding RTF be an enhancement that users will use?
If your USERS want to have it, then go for it! If not, sounds like work that won't be put in practice.
He may have no idea what he's doing, but his trade war is wrecking their economy. Really hard to keep an economy going when it is designed on small (or no) profit margins and costs keep changing quickly.
A user with rights in the ACCESS database would do the export. Goal is to make sure someone who is just doing the merge / send letters wouldn't be the one putting their fingers in the database.
Real world where I had to do this (admittedly 30 odd years ago) we were kicking data out from casino...
If you really want to keep this in an ACCESS database, you can create a "Side end" that has JUST what you want your query to return. This is filled by an append query in your primary database, is unencrypted, and filled BEFORE you run your mail merge. After you do your merge, you then have a...
For fun, try working out "Sunrise" on a moon tidally locked to a hot Jupiter. Depending on which side of the moon you are on, you get one or TWO per rotation around the main planet!
This may be because M$ found they have a market for the heat generated. Why waste it on ocean water when you can sell it to consumers to warm their homes?
https://www.bloomberg.com/news/features/2025-05-14/finland-s-data-centers-are-heating-cities-too
Many years ago we gave one of the soldiers in my unit a citation for "Properly demonstrating the method of securing both their vehicle and keys in one location". Yes, we gave them a humorous award for "Locking their keys in their car" three times.
Odd question, what is different between [FullName] and concatenating [FirstName] & " " & [LastName]? Normally you don't save something that is easily put together, especially when you will want to use it with either part first depending on circumstance.
At the root of the issue are the questions "What compensation should health care providers receive for their services?" and "As a society, how will we distribute resources so that some or all may benefit from healthcare?".