ACCDE files and updating

[Novaember]

Hi
This might sound stupid but I am very new at Access.

I see I can make an ACCDE file that will keep anyone from tampering with my queries etc. Which is awesome.

But what if I need to change something or add a new query or report. I can make my changes in the regular database but the ACCDE version does not get updated. I can't copy and paste the new or changed items into the ACCDE one.

How do I do that? I don't want people to be able to muck around in there but I also need to add and update queries/reports/forms.

I'm a bit clueless on all of this. If you can give me pointers on where to look to read up on this or just a quick 'how to' would be very helpful
Thanks for any pointers.
~Nova

 

[pbaldy]

You make your changes to the original accdb, create a new accde from it, and distribute that to your users. Most of us automate that by writing little utilities or using things like this:

http://autofeupdater.com/