Re: Multi users in one form

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

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: 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 ... permissions) on the folder where the backend is located. ...
    (microsoft.public.access.security)
  • Re: Can I link to reports in another database?
    ... The frontend is an MDE. ... The backend contains all the tables. ... in a second backend database. ... reports and expose them by modifying their manifestation as text. ...
    (comp.databases.ms-access)
  • Re: BackEnd Database Locking when FrontEnd runs a query - why?
    ... You can't make design changes in a Jet 4 db when anyone else is connected to ... No other db objects should be in the back end, including reports. ... The frontend has tables that are linked to ... In the backend, I do all the work of querying various datasources around our ...
    (microsoft.public.access.security)
  • Re: Access im Netz
    ... die dringende Empfehlung ist eine Aufteilung in Frontend und Backend. ... Im BE liegen nur die Daten, im FE die Formulare, Reports usw. ...
    (microsoft.public.de.access)