Access

Resolved · Medium Priority · Version 2007

Tue 25 Jan 2011, 15:49 Delegate Tracy said...

Tracy has attended:
Access Introduction course
Access Intermediate course

Access

The best way to lock a database so that I am the only person inputting data.

Mon 31 Jan 2011, 10:36 Trainer Andrew said...

RE: Access

Hi Tracy

I am sorry that we have not been able to get back to you as soon as we would have liked. We will be in touch shortly to progress your question.

Thank you for your patience.

Kind regards,

Andrew

Tue 1 Feb 2011, 14:16 Trainer Anthony said...

RE: Access

Hi Tracy, thanks for your query. While there are many ways to ensure exclusive access to a database, I'd recommend you start off by password protecting it. A walkthrough of this
is point 8 in the list linked to here:

http://www.techrepublic.com/blog/10things/10-tips-for-securing-a-microsoft-access-database/552

Hope this helps,

Anthony

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips