Replication - lost data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...
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
Click to expand...
incomplete
So, did you put your tables in the mdb that you call *Front End*?


Immanuel Sibero
 
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.
 
Pete,
links to them. Went for replication cos several users an though it good way
to keep everbody at same change level.
Click to expand...

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
 
Back
Top