Locking down a data base

[daveone23]

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?

[Micron]

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.

Maybe by "delete fields" you meant deleting data in fields.

[Welshgasman]

Yes, accde/accdr file.

[daveone23]

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?

[Micron]

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.

[Bulzie]

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.

[daveone23]

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.

[isladogs]

Have a look at my article: Improve Access Security 2 (isladogs.co.uk)

[daveone23]

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

[isladogs]

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.

[daveone23]

I am opening it in a very secure area. I got into the trust center and played around with the macro selections, nothing changed.

[daveone23]

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.

[Minty]

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.

[CJ_London]

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

[Bulzie]

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.