Database security

[javajom]

If I make my database a MDE file, will it allow me to do maintenance? As I have a date query that removes records that are passed a curtain date and appends them to another table, which will be ok for this year but will need to modify the query next year. If the file is locked totally then I won't be able to modify when it is running.

So I need a way that the database design is locked off to normal users allowing them to use it but will need a password for design so they can't mess with it. The password which will allow me into the workings to modify queries ect. Is that posible?

 

[pbaldy]

The normal process is to create an MDE from your MDB and distribute the MDE to users. You keep the MDB to make database changes later, at which point you create a new MDE for the users.

 

[javajom]

I had that thought, but if the users are using the MDE file the information will be on that so how do you transpose the data from the MDE to mine? Sorry I'm a newby at database.

 

[pbaldy]

A multi-user database should be split. More info that you'll ever want:

http://www.accessmvp.com/JConrad/accessjunkie/splitting.html

The best summary might be the second link down, to Allen Browne's site.