Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Replication - lost data?

Discussion in 'Information Technology' started by Pete Rothery, Jul 28, 2006.

  1. Pete Rothery

    Pete Rothery
    Expand Collapse
    Guest

    I have a split database, the front end is replicated, backend normal. When
    records are accessed from the data entry form in the frontend all fields are
    present and correct. But when I look in the table in the backend a (vital)
    memo field contains only the first line (a date). Can't find the rest of the
    memo anywhere! I want to unreplicate but when i import the table the memo
    fiels is incomplete - - its there smewhere?? Any help to recover data greatly
    appreciated.

    Pete R
     
  2. Loading...

    Similar Threads Forum Date
    Lost Treasures Of The Sikh Kingdom - BBC Documentary History of Sikhism May 28, 2016
    lost patrol Blogs Oct 16, 2015
    Self lost patrol Blogs Oct 11, 2014
    Heritage Lost Treasures of the Sikh Kingdom History of Sikhism Nov 21, 2014
    Malaysia Second Malaysian Plane Lost in only 4 months! Breaking News Jul 18, 2014

  3. Immanuel Sibero

    Immanuel Sibero
    Expand Collapse
    Guest

    Hi Pete,

    Hmmm.. replicated front end? Could you please describe what's in the front
    end and in the back end?
    Front End should contain everything but tables, Back End should contain
    tables only. You should replicate Back End only.

    Two things you said are contradictory to the above:

    > I have a split database, the front end is replicated, backend normal.

    You should only replicate the mdb file containing tables (i.e. commonly
    referred to as the Back End).

    > ..... I want to unreplicate but when i import the table the memo fiels is

    incomplete
    So, did you put your tables in the mdb that you call *Front End*?


    Immanuel Sibero



    "Pete Rothery" <PeteRothery@discussions.microsoft.com> wrote in message
    news:BEBA500B-3056-44E0-A46E-D6093D8CFBED@microsoft.com...
    > I have a split database, the front end is replicated, backend normal. When
    > records are accessed from the data entry form in the frontend all fields

    are
    > present and correct. But when I look in the table in the backend a (vital)
    > memo field contains only the first line (a date). Can't find the rest of

    the
    > memo anywhere! I want to unreplicate but when i import the table the memo
    > fiels is incomplete - - its there smewhere?? Any help to recover data

    greatly
    > appreciated.
    >
    > Pete R
     
  4. Pete Rothery

    Pete Rothery
    Expand Collapse
    Guest

    Hi Immanuel

    Thanks for quick response. Backend contains only tables, replicated frontend
    links to them. Went for replication cos several users an though it good way
    to keep everbody at same change level.


    "Immanuel Sibero" wrote:

    >
    >
    > Hi Pete,
    >
    > Hmmm.. replicated front end? Could you please describe what's in the front
    > end and in the back end?
    > Front End should contain everything but tables, Back End should contain
    > tables only. You should replicate Back End only.
    >
    > Two things you said are contradictory to the above:
    >
    > > I have a split database, the front end is replicated, backend normal.

    > You should only replicate the mdb file containing tables (i.e. commonly
    > referred to as the Back End).
    >
    > > ..... I want to unreplicate but when i import the table the memo fiels is

    > incomplete
    > So, did you put your tables in the mdb that you call *Front End*?
    >
    >
    > Immanuel Sibero
    >
    >
    >
    > "Pete Rothery" <PeteRothery@discussions.microsoft.com> wrote in message
    > news:BEBA500B-3056-44E0-A46E-D6093D8CFBED@microsoft.com...
    > > I have a split database, the front end is replicated, backend normal. When
    > > records are accessed from the data entry form in the frontend all fields

    > are
    > > present and correct. But when I look in the table in the backend a (vital)
    > > memo field contains only the first line (a date). Can't find the rest of

    > the
    > > memo anywhere! I want to unreplicate but when i import the table the memo
    > > fiels is incomplete - - its there smewhere?? Any help to recover data

    > greatly
    > > appreciated.
    > >
    > > Pete R

    >
    >
    >
     
  5. Immanuel Sibero

    Immanuel Sibero
    Expand Collapse
    Guest

    Pete,

    > links to them. Went for replication cos several users an though it good

    way
    > to keep everbody at same change level.


    Not a good idea. Matter of fact, it could even be a bad idea. You should
    avoid it.
    To keep everybody at the same change level, simply send each of them a copy
    of the Front End. And I mean a copy and a replica. I would fix this first.

    As for your original problem. Sounds like it may be some kind of corruption.
    I would try the standard things like:
    - Compact and repair the Back End
    - Create a blank copy of mdb and export to it everything in the Back End.

    If that fails, I would check out:
    http://www.granite.ab.ca/access/tipsindex.htm

    There is a section dealing with corruption. Lots of other information that
    may be of help and interest to you.



    HTH,
    Immanuel Sibero


    "Pete Rothery" <PeteRothery@discussions.microsoft.com> wrote in message
    news:F5E9F002-F000-42C1-9EF4-BDAA08FD0BDD@microsoft.com...
    > Hi Immanuel
    >
    > Thanks for quick response. Backend contains only tables, replicated

    frontend
    > links to them. Went for replication cos several users an though it good

    way
    > to keep everbody at same change level.
    >
    >
    > "Immanuel Sibero" wrote:
    >
    > >
    > >
    > > Hi Pete,
    > >
    > > Hmmm.. replicated front end? Could you please describe what's in the

    front
    > > end and in the back end?
    > > Front End should contain everything but tables, Back End should contain
    > > tables only. You should replicate Back End only.
    > >
    > > Two things you said are contradictory to the above:
    > >
    > > > I have a split database, the front end is replicated, backend normal.

    > > You should only replicate the mdb file containing tables (i.e. commonly
    > > referred to as the Back End).
    > >
    > > > ..... I want to unreplicate but when i import the table the memo

    fiels is
    > > incomplete
    > > So, did you put your tables in the mdb that you call *Front End*?
    > >
    > >
    > > Immanuel Sibero
    > >
    > >
    > >
    > > "Pete Rothery" <PeteRothery@discussions.microsoft.com> wrote in message
    > > news:BEBA500B-3056-44E0-A46E-D6093D8CFBED@microsoft.com...
    > > > I have a split database, the front end is replicated, backend normal.

    When
    > > > records are accessed from the data entry form in the frontend all

    fields
    > > are
    > > > present and correct. But when I look in the table in the backend a

    (vital)
    > > > memo field contains only the first line (a date). Can't find the rest

    of
    > > the
    > > > memo anywhere! I want to unreplicate but when i import the table the

    memo
    > > > fiels is incomplete - - its there smewhere?? Any help to recover data

    > > greatly
    > > > appreciated.
    > > >
    > > > Pete R

    > >
    > >
    > >
     
  6. Immanuel Sibero

    Immanuel Sibero
    Expand Collapse
    Guest

    Oops, typo:

    > And I mean a copy and a replica.


    The above should read:
    And I mean a copy NOT a replica.


    Immanuel Sibero


    "Immanuel Sibero" <goahead@getlost.com> wrote in message
    news:uSRGOE%23kGHA.5072@TK2MSFTNGP04.phx.gbl...
    >
    > Pete,
    >
    > > links to them. Went for replication cos several users an though it good

    > way
    > > to keep everbody at same change level.

    >
    > Not a good idea. Matter of fact, it could even be a bad idea. You should
    > avoid it.
    > To keep everybody at the same change level, simply send each of them a

    copy
    > of the Front End. And I mean a copy and a replica. I would fix this first.
    >
    > As for your original problem. Sounds like it may be some kind of

    corruption.
    > I would try the standard things like:
    > - Compact and repair the Back End
    > - Create a blank copy of mdb and export to it everything in the Back End.
    >
    > If that fails, I would check out:
    > http://www.granite.ab.ca/access/tipsindex.htm
    >
    > There is a section dealing with corruption. Lots of other information that
    > may be of help and interest to you.
    >
    >
    >
    > HTH,
    > Immanuel Sibero
    >
    >
    > "Pete Rothery" <PeteRothery@discussions.microsoft.com> wrote in message
    > news:F5E9F002-F000-42C1-9EF4-BDAA08FD0BDD@microsoft.com...
    > > Hi Immanuel
    > >
    > > Thanks for quick response. Backend contains only tables, replicated

    > frontend
    > > links to them. Went for replication cos several users an though it good

    > way
    > > to keep everbody at same change level.
    > >
    > >
    > > "Immanuel Sibero" wrote:
    > >
    > > >
    > > >
    > > > Hi Pete,
    > > >
    > > > Hmmm.. replicated front end? Could you please describe what's in the

    > front
    > > > end and in the back end?
    > > > Front End should contain everything but tables, Back End should

    contain
    > > > tables only. You should replicate Back End only.
    > > >
    > > > Two things you said are contradictory to the above:
    > > >
    > > > > I have a split database, the front end is replicated, backend

    normal.
    > > > You should only replicate the mdb file containing tables (i.e.

    commonly
    > > > referred to as the Back End).
    > > >
    > > > > ..... I want to unreplicate but when i import the table the memo

    > fiels is
    > > > incomplete
    > > > So, did you put your tables in the mdb that you call *Front End*?
    > > >
    > > >
    > > > Immanuel Sibero
    > > >
    > > >
    > > >
    > > > "Pete Rothery" <PeteRothery@discussions.microsoft.com> wrote in

    message
    > > > news:BEBA500B-3056-44E0-A46E-D6093D8CFBED@microsoft.com...
    > > > > I have a split database, the front end is replicated, backend

    normal.
    > When
    > > > > records are accessed from the data entry form in the frontend all

    > fields
    > > > are
    > > > > present and correct. But when I look in the table in the backend a

    > (vital)
    > > > > memo field contains only the first line (a date). Can't find the

    rest
    > of
    > > > the
    > > > > memo anywhere! I want to unreplicate but when i import the table

    the
    > memo
    > > > > fiels is incomplete - - its there smewhere?? Any help to recover

    data
    > > > greatly
    > > > > appreciated.
    > > > >
    > > > > Pete R
    > > >
    > > >
    > > >

    >
    >
     

Share This Page