Home All Groups Group Topic Archive Search About
Author
10 Mar 2009 3:05 AM
Irene
i have a database which is using Microsoft access to do. i would like to ask
is it possible to lock the table? cos i no want the user simply go in the
table to modify the data. so is it have any idea to do it? thanks!

Author
10 Mar 2009 11:39 AM
Keith Wilby
"Irene" <Ir***@discussions.microsoft.com> wrote in message
news:817E2D24-D57C-4457-827B-75341A00EE46@microsoft.com...
>i have a database which is using Microsoft access to do. i would like to
>ask
> is it possible to lock the table? cos i no want the user simply go in the
> table to modify the data. so is it have any idea to do it? thanks!

Hide the database window and provide locked forms for your users.

Keith.
Author
11 Mar 2009 12:12 AM
Irene
thanks for the reply. but can u tell me how to Hide the database window and
provide locked forms for your users? thanks!

Show quoteHide quote
"Keith Wilby" wrote:

> "Irene" <Ir***@discussions.microsoft.com> wrote in message
> news:817E2D24-D57C-4457-827B-75341A00EE46@microsoft.com...
> >i have a database which is using Microsoft access to do. i would like to
> >ask
> > is it possible to lock the table? cos i no want the user simply go in the
> > table to modify the data. so is it have any idea to do it? thanks!
>
> Hide the database window and provide locked forms for your users.
>
> Keith.
>
>
Author
12 Mar 2009 9:35 AM
Keith Wilby
"Irene" <Ir***@discussions.microsoft.com> wrote in message
news:AD04D5E7-9A7C-42A9-B4D0-1E7CBA0B8A01@microsoft.com...
> thanks for the reply. but can u tell me how to Hide the database window
> and
> provide locked forms for your users? thanks!
>

Set the database window start-up properties in Tools, Startup.  Each form
has a "locked" property, set this to "Yes".