Recent content by frero

isladogs, you're my hero :) and thanks to GPGeorge for this additional information. I add "distinct" and it works as I expect it to. I admit that when I use ‘distinct’, I didn't pay attention to the readOnly transition. I understand your explanation about the snapshot, even though I don’t...

Look at Gasman’s signature, it says it all. Users must respond to ministerial surveys, with requests that change daily. I think it's more efficient to teach them basics of queries, than locked solutions. And with access, make (basic) queries is not so difficult thanks to GUI. If anyone has...

Hello everyone and thank you for your replies That's what I thought ! To make things clearer, I've attached a photo of the app's structure. The idea is to let users make their own queries, but without the risk of losing data. So I was thinking of using intermediate Snapshot requests as a kind...

Hello every one I have an Access application with separated data. I want to explain to some users how to create their own selection queries. To prevent users from directly accessing the data, I created a dedicated front-end that contains snapshot selection queries on all tables. But I was...

Hello everyone, I am French and I do research in mechanics. In parallel, I develop tools to simplify the lives of administrative staff. I often encounter problems with Access, and I have no doubt that I will find answers here. Thank you all in advance.