I'd like to see your code, Bill. Too bad the downloads couldn't be ported to this platform too. Thanks for all you've shared, and keeping this group going. I've learned many things from you that have helped me to have a better foundation and understanding.
Patty, Access is a great tool to build with. Since Access can link to other databases, you can keep your user interface and move the data -- back-end(s) (BE)(s). If you have have greater needs for data security, then the BE(s) should move to a platform where that's better with that such as SQL Server. However, lots of security issues with Access can be resolved by putting a back-end in a place where only those who have rights can get to it.
If by 'Securing Access apps', you meant VBA, then you can put a password on your code. As a teacher, I think it's a bad idea and don't do it myself. You can also distribute as ACCDE such that others can use your application but can't change your user interface designs. However, others active in the project needs to have the ACCDB file so the application can be modified and keep working for the future.
~~
added in past responses under Bill's reply.
Duane uploaded an example of how to keep previous posts here:
https://groups.io/g/MSAccessProfessionals/photo/249167/2977001
and Giorgio added on that other email clients may have a different method such as an Advanced Setting to "Insert the original email text to a reply"
~~
Happy 2025 ... this is a square year (square of 45)
kind regards,
crystal
===============
Hi Patty, How are you with Access VBA? I have some code samples that are for Access 2010 but you might be able to use parts of them. There is code for NT users, SQLServer and workgroups. Let me know.--Regards,Bill Mosca, Founder - MS_Access_ProfessionalsMicrosoft Office Access MVP 2010-2016My nothing-to-do-with-Access blog
So no need for Active Directory?
On 11/11/2024 4:35 PM CET Tony Meece via groups.io <mr_7ony=yahoo.com@groups.io> wrote:The MICROSOFT user account can be read from ACCESS.
On Mon, Nov 11, 2024 at 7:24 AM, Patricia Mapes via groups.ioThanks Duane!
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom via groups.io
Sent: Saturday, November 9, 2024 2:40 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Securing Access apps
Hi Patty,
Google this "securing MS Access applications" to get a more comprehensive answer than you would get in a reply.
Duane
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Patricia Mapes <patty.mapes@gmail.com>
Sent: Thursday, November 7, 2024 8:49 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Securing Access apps
Does anyone have a good method (other than using a database properties password?
Thanks,
Patty
===============
