Re: Replication problem

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

"Neil L via AccessMonster.com" <u12202@uwe> wrote in
557a9f2902115@uwe:">news:557a9f2902115@uwe:

> David W. Fenton wrote:
>>> The copy is the design master but it crashes when i try to open
>>> it, the replica works fine but when i changed it to the design
>>[quoted text clipped - 6 lines]
>>> crashes and gives you the menu saying access has encounted a
>>> problem etc
>>
>>Do you have forms and reports in your replicated database? If so,
>>that's likely the problem. Replication really works only for
>>tables and queries -- replicating anything else is a crapshoot
>>that often ends up corrupted and unusable.
>
> is there any other way of sharing a database with forms reports
> etc which wont crash the database

First off, there is one basic thing about *all* Access applications
that for some reason many people never seem to realize:

The application should be split into two parts:

1. an MDB with just the data tables. One copy of this is on your
server and shared by everyone. This is called the BACK END.

2. an MDB with the forms, reports, macros and modules that is linked
to the tables in the data MDB. All users should have their own
copies, so that no front end is opened by more than one user at a
time. This is called the FRONT END.

Since there's no data in the front end, to give a user a new one, it
just has to be copied to their computer, over to of the old one.
This can be done manually in Windows Explorer, by executing a batch
file, or by using a utility like the one created by Tony Toews for
automatically distributing front end updates (see
http://www.granite.ab.ca/access/autofe.htm).

I've used all three methods in different circumstances and it's no
big deal at all.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
.

Relevant Pages

  • Re: Replication problem
    ... The copy is the design master but it crashes when i try to open it, ... replica works fine but when i changed it to the design master that crashed ... fine in the database before its replicated or it crashes and gives you the ...
    (microsoft.public.access.replication)
  • Re: Replication problem
    ... > The copy is the design master but it crashes when i try to open ... the replica works fine but when i changed it to the design ... > when i open the design master i get either an error saying invalid ... > but these work fine in the database before its replicated or it ...
    (microsoft.public.access.replication)
  • My Replication Design Question
    ... sync or internet sync) and cannot install anythird party controls (i.e. the ... I have two different networks in which my design master is installed. ... makes a replica of the design master. ... import the data from the excel sheet into their replica into temporary ...
    (microsoft.public.access.replication)
  • Re: How to copy Design Master as a Design Master.
    ... Stop the users from using the design master as a backend database. ... Research "replica farms" for more information on that. ... their DesignMaster copied to my support machine for diagnose purpose. ...
    (microsoft.public.access.replication)
  • Re: Best way to have a db for development and other for production
    ... i can get the real Design Master from the production ... >> replica i cannot change any object in the test database. ...
    (microsoft.public.access.replication)