Is it possible...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
Is it possible to have access open a specified form e.g. Trade Form,
each time a user launches the application.
Click to expand...

Tools, startup and you'll see the option to set the opening form.
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.
Click to expand...

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
 
Back
Top