Hi

Is it possible to have access open a specified form e.g. Trade Form, each
time a user launches the application.

Also when assigning permissions to users for the various forms, I noticed
that the read data, update data, insert data and delete data options are
grayed out.  Is there a reason for this and what can be done to make these
options available.

Thanks

microsoft wrote:
Tools, startup and you'll see the option to set the opening form.

These don't apply to forms.  Instead you'd need to set these permissions on
the table/query that is the recordsource for the form.

I think you are much better off having each user have their own copy of the
front end.  Couple of reasons.  1.  If one copy of that file gets corrupted,
then everyone else will be fine.  2.  If you have lots of forms, it greatly
reduces the amount of network resources needed.  3.  Ensures that Access is
tracking that one user, and not someone else.  I understand that updating the
front end is a concern.  I had a similar concern when I made a database for
use by about 200 people.  I used a simple solution that used two tables (one
on the back end and one on the front end).  It compared a value in the two
tables (the database version number) and if the two were different, it
automaticlly ran a routine to download the new front end.

If you need more help, feel free to drop me a line.

Troy

Show quoteHide quote

Credit Card Masking
Security without signon
Creating a secure database on a network
Basing Object Permissions on Ownership
Access Tools Menu Disabled
Creating user-level security with MS Access file on a network
Access security best practice - Stupid question(s) #2
Access Security
Invalid page fault in module RPCRT4.dll
Prompting Users for a new password