access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · Medium Priority · Version 2007

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.

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

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


 

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


Server loaded in 0.1 secs.