security issue

[javajom]

Hi,
what I trying to do is let the database run for 6 months and then be password protected, giving me a chance to do the maintenance on it run queries, append tables and update formulars. I have set the spreadsheet to do the same.

So I need a module to run on start up, compare the date and if true lock off with a password. Please help.

 

[KeithG]

You are going to have problems doing this because holding down the shift key when open the database will bypass and code that is suppost to run on start up.

 

[KeithG]

If you are trying to prevent design changes you could make your db an mde file

 

[javajom]

If you are trying to prevent design changes you could make your db an mde file

I'm just a beginner, how do i do that?

 

[KeithG]

Go to Tools=>Database Utilities=>Make MDE file

 

[javajom]

If I do this 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 is locked off to normal users so they can't mess with it and a password, which will allow me into the workings to modify queries ect.