John,
Thanks for the prompt help. It is working. One more question, is
it possible to load only the form and hide the access program with
its menus and the database window? I want to display just the form
while launching a mde similar to Visual basic exe. The users should
have access only to the command buttons on the form.
Thanks and Regards,
Kumar
--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote:
>
> Kumar-
>
> Open the database to the database window. Choose Tools /
Security / User
> and Group Permissions.
>
> Choose Object Type Table, select the table in the list, and clear
the Update
> Data, Insert Data, and Delete Data check boxes for the Admin user
and apply
> the changes. Select the Groups list and the Users group and clear
the same
> check boxes and apply the changes.
>
> A really sharp user could go to this security dialog and re-enable
these
> permissions, but this will at least prevent "accidental" changes
to your
> table.
>
> John Viescas, author
> "Building Microsoft Access Applications"
> "Microsoft Office Access 2003 Inside Out"
> "Running Microsoft Access 2000"
> "SQL Queries for Mere Mortals"
> http://www.viescas.com/
>
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf
> Of access_kri
> Sent: Monday, November 21, 2005 12:20 PM
> To: [email protected]
> Subject: [ms_access] Looking Table for Data Entry or editing
>
> Dear All,
> Is there a way to prevent any changes to table data or
adding new
> record to the table. I have designed an Engineering Table which
contains
> standard dimensions for a given valve size and rating. The table
is based on
> relevant Standards and it cannot grow as all the possible sizes
are covered.
> I have a form which requires users to select the size and rating
and the
> other dimensions are displayed.
> The form selected is single form without any navigation buttons
and does not
> allow data entry. However, I do not want to hide the table, but
prevent any
> fiddling with the table data even accidently by me or any other
user.
> Thanks in advance.
>
> Regards,
> Kumar
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor --------------------
~--> Get
> fast access to your favorite Yahoo! Groups. Make Yahoo! your home
page
> http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM
> -------------------------------------------------------------------
-~->
>
>
> Yahoo! Groups Links
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
