Re: Unable to edit form while others are in table

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

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 09/22/04 

Date: Tue, 21 Sep 2004 20:06:26 -0600

On Tue, 21 Sep 2004 13:15:03 -0700, "Pete"
<Pete@discussions.microsoft.com> wrote:

>Does anyone have a suggestion to correct this problem.

two:

- Use Access97 or an earlier version
- Do your form design in a separate database not shared with anyone
else

Unfortunately, Access 200x simply does not allow multiple users to
make changes to the forms/reports/code simultaneously. This is one of
many reasons to use the Database Splitter Wizard to split the tables
into one .mdb file and the user interface into another; you can edit
your own copy of this "frontend" database exclusively, and make it
available to the other users when you're done without affecting the
data.

                  John W. Vinson[MVP]
             Join the online Access Chats
        Tuesday 11am EDT - Thursday 3:30pm EDT
      http://community.compuserve.com/msdevapps

Relevant Pages

  • RE: automatically populate a field in a form
    ... The sample Northwind database has many examples you can look at. ... Window) from the database window. ... Properties from the form design window. ... The Control Source property is where the control gets its data, ...
    (microsoft.public.access.forms)
  • Re: unable to set a default value to multi-column combo box
    ... to do is to extract a list of course IDs from the database. ... I am checking the code and form design again. ... You mentioned that I can just set the DefaultValue property in form ...
    (microsoft.public.access.formscoding)
  • Form/Table Locked
    ... I'm at an impasse! ... database is opened I have it set so the form opens first. ... go into form design or even try to close Microsoft Access I get ...
    (microsoft.public.access.gettingstarted)
  • Re: Allen Browne Search Code
    ... It is difficult to guess your table structures, relationship and form design ... with seeing the database. ... Have you look into one of the problems with subform filtering from Allen ... Thanks for any guidance! ...
    (microsoft.public.access.formscoding)
  • Re: Update form formatting on FLY?
    ... > I have a small database with a form which is periodically changed. ... the form design. ... Public Sub SetupForm ... For Each ctl In frm.Controls ...
    (comp.databases.ms-access)