Delete Forms and Reports after specific period

[history]

Hello Friends,

I've a new question
How do I delete Forms and Reports after specific period ?
What I need exactly : after specific period all Forms and Reports will be deleted without control from the user.

which method should I use to do that ?

Thanks a lot in advance

 

[vbaInet]

Can we ask why you're looking to do that?

 

[SteveSchapel]

Agreed. I can't imagine any database scenario where this would be applicable. So it would be good to put into context by explaining the purpose you are trying to achieve.

 

[history]

Hello my dear Friend

Yes, sure you can ask,,,
I'm looking to do that as a protection way to my database for not spreading it to others without my authority.
Unfortunately, MS Access hasn't any option to convert the file to be exe where I can put some restrictions but as you know MS Access so weak in protection and you can break any password or cancel the SHIFT key ....etc

That's my point because I spent more than 5 months in designing my db and don't want to be for others without my will.

 

[vbaInet]

You can distribute an MDE front-end to your users and setup a lockdown after a certain date as the db loads. Will that sort of thing work for you?

 

[history]

I couldn't get your point
I'm sorry, but can you declare more ?

 

[vbaInet]

An mde file ensures that users cannot get access to your code or be able to make design changes or even be able to create reports or forms. I will see if I can find some links regarding this.

 

[vbaInet]

Here are some links on MDEs:

http://www.dummies.com/how-to/content/securing-your-access-2003-database-as-an-mde-file.html

http://www.databasedev.co.uk/converting-ms-access-files.html

By the way, are you going to have a front end and a back end?

 

[history]

Thanks a lot my dear brother

I'll have a look

 

[history]

I've an error message while converting to mde

Microsoft Office Access was unable to create the .accde, .mde, or .ade file

why this message appears ?

 

[vbaInet]

Is it the same Access version that you created your database in?

I would also advice that you perform this on a backup copy of your database.

 

[history]

I tried to do this in both : mdb and accdb

 

[vbaInet]

I would imagine you have written some code right? Go into the vbe editor window (which is the code window), click Debug menu and then click Compile.

 

[history]

What can I say to you
No words can be enough to describe my feelings towards you

Thank you so much my brother
I'm so appreciated and so proud to be one of your students

GOD bless you

 

[vbaInet]

God bless you too

Remember that willonly stop the users from making any changes to the forms, reports etc but they are allowed to use it.

 

[history]

Yes brother, you're right

All I need to prevent any one to take any unauthorized copy from any objects or codes
but they can use no problem

and now I think I can protect my db by HDD serial and no one can see the equation I put in the code ,,, am I right or not ??

Another query :
MDE file can be broken or not ???

 

[vbaInet]

Nobody can see the code because there is no code attached to it