Re: Multi-user Database Set Up

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I wonder if this might be my problem, I have one access mdb file, that is on
a network server and when two or more people are opened on the file, one
machine or the other gets locked up and will not let the other person print a
report and the database is suppose to open in "Shared Mode" with
record-locking engaged. It sounds like I need to split out the tables to
another mdb, linked to a front-end to prevent this from happening. This is
version 2003.


"Douglas J. Steele" wrote:

Access is multi-user right out of the box, but the best practise is to split
the database into a front-end (containing the queries, forms, reports,
macros and modules), linked to a back-end (containing the tables and
relations). Only the back-end should be on the server: each user should have
a copy of the front-end on his/her hard drive.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"MichelleM via AccessMonster.com" <u44423@uwe> wrote in message
news:9863d169e016a@xxxxxx
I am familiar with Access, how to create, tables, forms, queries, and
reports
and how they all link together and use for a single-user mode. However, I
have a project to create a multi-user database, I would appreciate any
advice
on what I need to consider prior to setting up. Thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200906/1




.

Relevant Pages

  • Multiple Users being blocked
    ... I have a database that is split. ... The back-end is on a network server and the ... front-end is on each individual user's desktop. ...
    (microsoft.public.access.forms)
  • Data disappearing - without apparent cause
    ... to store the merged documents in different places on their PC's (or ... even on the network server where the BE is), ... fields is actually local to the FE part of the database, ... Note that it is not envisaged that users will change the folder ...
    (comp.databases.ms-access)
  • Re: Slow response on only one PC
    ... I have an Access application installed on a network server that is ... Recently, for one user, the response time has been unacceptable ... database from the server to the local drive of the problem PC and ran ... The PC system data is: ...
    (comp.databases.ms-access)
  • Re: Revolution 1309
    ... Still it could be permissions issues on resources other than the Access MDB file. ... Since the client app is wholly contained within a VB6 app, and all data access is being performed via ADO, there would be no need to have Access installed anywhere (except, maybe, the server, if the server has been used to run Access as a database maintenance tool). ... MS WSUS Website: http://www.microsoft.com/wsus ...
    (microsoft.public.cert.exam.mcse)
  • Re: j:(my File).mdb is not a valid path. Make sure the path name is
    ... Neil ... > j:\.mdb is not a valid path. ... > There are only two files on the network server. ... > the database. ...
    (microsoft.public.windowsxp.help_and_support)