Recent content by P J Bryant

Of course it depends on circumstances, but as the original post didn't have those details my answer remains a valid proposition. It's one I have used many times for many clients since the 90's and has always worked really. Clearly YMMV; but if it suits the OP's setup, then it could work well...

If your client's network is an Active Directory managed network then you can use AD security groups to control anything in Access. A major advantage is that you can delegate the management of those groups to the IT staff. I've done it many times - on starting a db, identify the groups in AD of...

Some of you will know me and that (along with Andrew and Steve, and until recently Rod) I co-chair the 31 years and still going UK Access User Group. I've been an Access/SQL dev since the 90's; I used to pretty much permanently live on beta versions of Windows and Office - happy days! I'm...