By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 1,454 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Demo Database for Time Limit Run

P: 57
Hello Friends
I want to include a time limit when a Demo Database run. Suppose I want my database run for 15 days and then it must Locked or Not Accept the User. Any guidance for this trick.

thanks
irsmalik
2 Weeks Ago #1
Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,128
I'm not sure exactly what you are after here. Perhaps I can see a time limit of several hours, but more than two weeks? I'm not sure I see the purpose.

However, there are as many different ways of determining time lapsed as there are developers. You just need to use one of those formulas and insert it into your form's timer event. Then, when the time is reached, you can either shut down the DB or lock all the controls.
2 Weeks Ago #2

P: 57
Dear Twinnyfo
I have already mentioned about a Demo Database which I provided to any other user. I want a hidden function or event some thing like.. from today + 15 days. After 15 days the database must not accept user name and password. I mean database must not open.
I need guidance how to create a function and then where to place it.

irsmalik
2 Weeks Ago #3

twinnyfo
Expert Mod 2.5K+
P: 3,128
Well, your explanation is just slightly more clear than before, but at least now I think I understand what you are talking about.

One thing to remember about Access, is that in order for it to determine if it is going to open or not, it needs to open. Additionally, it is neraly impossible to make an Access DB "Break-proof". Passwords will help.

So, if you do have a password on your database, the problem comes that you cannot change a password on an open DB. So, instead you might want to use some form of "splash" form that opens when the DB is opened. The first time the DB is opened, it saves the date/time. After that, each time the DB is opened it checks current date/time and compares the two. If it is more than 15 days, then the DB quits.

The problem comes that a savvy DB hacker would be able to change the original opening date/time.

The bottom line is that something like this can be done, but it's really outside the norm of how Access was designed. However, the above might help point you in the right direction.
2 Weeks Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.