Is there a way that I can lock down a data base so that no one can modify it (design view) yet still be able to add and delete records/fields?
Is there a way that I can lock down a data base so that no one can modify it (design view) yet still be able to add and delete records/fields?
I think you have a catch-22 question there. You can't prevent design changes and still be allowed to add or delete fields. Adding or updating records would be a normal function of the db, whether locked down or not. Perhaps you are needing to convert a db copy to an .accde? That would prevent design changes to db objects.Is there a way that I can lock down a data base so that no one can modify it (design view) yet still be able to add and delete records/fields?
Maybe by "delete fields" you meant deleting data in fields.
Last edited by Micron; 02-09-2024 at 10:58 AM. Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Yes, accde/accdr file.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I did that and when I run it, it comes up with a warning that it could contain harmful information. That would scare most end users away from using it. Is there a way to remove that warning?
Should not happen if you put the files in a Trusted Location. Exception could be if the files were downloaded from the web, but I think that is not the case here.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Just to clarify, you want them to be able to enter data, just not change anything with the design? Not sure how "secure" you want it, you could disable the Shift key in code OnOpen and hide the ribbons, etc.
Yes, enter data, not change the design. I converted the file on my system like you guys said but i get that file warning message. No web transfer.
Have a look at my article: Improve Access Security 2 (isladogs.co.uk)
I took a look at that article, more of a book and way above my knowledge. I am a novice user. I just need to get rid of that initial warning message when opening up the compiled data base
To get rid of the message, run it from a trusted location as already mentioned.
My article covers all the steps needed to lock down your database to make it reasonably secure which is the subject line for this thread.
Last edited by isladogs; 02-12-2024 at 02:14 AM.
Ok, I "CREATED" a trusted area on my hard drive and it works BUT can I expect every user that download my data base to set up a "trusted" area. Seems like a real hassle.
If they put it their main Documents folder, that should already be a trusted location. It's a one time operation to add a trusted location.
If it makes you feel any better, you would have the same hassle with a macro enabled Excel workbook. It's part of Microsoft's attempts to "protect" us from ourselves.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
You can use an installer for the user to run. The installer can add a trusted location to the windows registry then copy the file to the specified directory and perhaps create a shortcut on the user’s desktop.
otherwise include some instructions as to how the user should install your app
Is there a windows command line to set a trusted location? I usually do this manually through Access but would be nice to add to a vb.exe I use to create the folder on harddrive, and copy the database to it.