I've seen issues like this caused by an unreliable network (bad hardware),
unexpected server restarts, or three finger salutes (CTRL, ALT & DEL) by end
users killing the FE while the . As a previous writer identified, a corrupt
form could also cause the issue. You might get a copy of ldbview.exe and see
what user is causing the corruption. This application will tell you what user
is having or had 'suspect' transactions.
I uploaded the LDBview.exe to the files section of this group.
TJ
--- vjcross2004 <[EMAIL PROTECTED]> wrote:
> I'm still having this problem & can't seem to find away around it.
> Any suggestions, greatly appreciated.
> TIA
> Jane
>
> --- In AccessDevelopers@yahoogroups.com, "vjcross2004" <[EMAIL PROTECTED]>
> wrote:
> >
> > I have a Access 2000 database split FE/BE (FE on user's PCs, BE on
> > server), running on Access 2003.
> > It has been working fine for a few years now (through various
> mods).
> > I recently added 2 new tables to the BE (Enquiries & Enquiry
> Lines)
> > The BE has about 30 tables. Now odd records in the Enquiry Lines
> are
> > getting corrupt (either gibberish or #error# in each field) every
> > couple of days or so. The table at the moment contains about 300
> > records (72 fields). I can compact & repair & then delete the
> > problem record & everything is back to normal for another couple
> of
> > days. It is always the same table, never one of the others.
> >
> > I've tried creating a new data BE & importing all the tables, but
> > the problem persists.
> >
> > My instinct to to blame a piece of hardware (PC, network card,
> > server etc), but that maybe because I'm a software programmer!
> Does
> > anyone have any suggestions as to how I might track down the
> problem?
> >
> > Thanks
> > Jane
> >
>
>
>
>
>
__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
