Re: Multi users in one form

Tech-Archive recommends: Fix windows errors by optimizing your registry

I thought I had done it, I placed a copy of the front end in a new folder in
each of their desktops and then a shortcut to this front end and also to the
security file. However, stil when two people try to run the same form, it
says they are locked out.
I know this is how it should run but how do i get around it as I need
several users in one form at one time.

Matt

"Joan Wild" wrote:

Matt, the only place that data is stored is in tables. Data is not stored in
queries, forms, reports, modules, macros, or in table links. Only in the
tables in the backend.

The multiple database you'll have are called frontends - these contain no
data. They do contain table links - but these are just links to the actual
tables in the backend. All your queries/forms/reports in the frontend will
be retrieving data from the backend.

You should have no issues with multiple users. Each user will have a copy
of the frontend on their PC. Each frontend links to the single backend on
the server. The backend is the only place where data gets stored. It is
important that all users have read/write/create/delete permission (Windows
permissions) on the folder where the backend is located.


--
Joan Wild
Microsoft Access MVP

Matt Dawson wrote:
Sorry Mousescroll is just soemthing that disables the mouse scroller
when they are in forms so they cant navigate through.

Agents have access only to two forms in the whole database, whilst
two users have access to all reports and queries. If i give each user
a front end, does each users information still write to the back-end
and in turn update the queries and reports in everyone's front end?

I am just worried, this leads to multiple databases and the relevant
information will not update!

Plus, if someone is writing to the back-end wont it stop other users
from writing at the same time?

Matt

"Keith Wilby" wrote:

"Matt Dawson" <MattDawson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A1E9845C-83DC-4424-B41B-4A4EB316FFEB@xxxxxxxxxxxxxxxx
Oh sorry I think i get you, they write to the backend, which in turn
updates
the data in the tables and the relevant queries/reports?

They dont create their own, no, they are already created. I assume
i leave the security in the same end as the backup file. Will each
user then need the
mousescroll in the same folder as the front ends?


Mousescroll?

As for security, to fully understand and implement it I'd recommend
you read the MS FAQ (link on my web site).

Regards,
Keith.
www.keithwilby.com



.

Relevant Pages

  • Re: lost joins in frontend
    ... Make sure to keep the queries in the frontend. ... Hopefully you will experience much less corruption from now on. ... Would it make sense to relocate the queries into the backend? ...
    (microsoft.public.access.queries)
  • Re: Error 3045 Follow Up Question
    ... > An ldb file is created in the same folder as the mdb. ... If you are working on the frontend on the ... > the backend folder. ... then that user does not have create permission on the ...
    (microsoft.public.access.security)
  • Re: Trying to merge modified copy of database with original.
    ... have them in the same folder on the hard drive), ... if you have six users, you need six copies of the frontend. ... The backend is in a shared folder; the frontend should NOT be shared, ... The mde file has all the design tools disabled so ...
    (microsoft.public.access.queries)
  • Re: Multi users in one form
    ... queries, forms, reports, modules, macros, or in table links. ... tables in the backend. ... All your queries/forms/reports in the frontend will ...
    (microsoft.public.access.security)
  • Re: Error 3045 Follow Up Question
    ... > has subfolders one for all backends and then one folder each for the ... > to the frontend on the local machine or backend on the network? ... frontend on each local machine and they are opening it, ... then that user does not have create permission on the ...
    (microsoft.public.access.security)