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

How do I timelock a database? Help please

P: n/a
Vic
Hi, I'd like to timelock a database, ie., let someone use it for a set
amount of time and then lock it down. How is this done?

Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Vic" <tr*******@hotmail.com> wrote in message
news:a6********************@adelphia.com...
Hi, I'd like to timelock a database, ie., let someone use it for a set
amount of time and then lock it down. How is this done?


There seems to be no feasible, or reasonable, way to timelock a database for
a particular time period after it is installed. You can do it in code, from
a fixed date, and spread the information to try to obscure it, pulling it
together in code from those various "pieces", compile the code. I've done
that, and it seemed to work, but the users who'd have wanted to break it
were not sophisticated. I suspect that an experienced hacker could break it.

The most-recommended way for a trial database (which I assume is your reason
for wanting a timelock) is to limit the number of records permitted in some
crucial tables by validation rules, and using a split database, with the
front-end only having read-with-owner-permissions queries access to the back
end. If you'll download the security FAQ from http://support.microsoft.com,
splitting and RWOP queries are discussed.

But, access security itself is breakable. And, so is the security for many
high-dollar software packages available commercially. You take a chance with
any scheme, if you become a target of the breaker-community.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.