Thanks Cathy for your suggestions. I am going to visit the client tomorrow to try to see what I can do. I will recreate the form where they enter the enquiries & maybe that will sort it. I've also just read about a /decompile command line option which could possibly help.
Thanks Trent for your suggestions. I will have a go with ldbView & see what happens. In the past I've too had problems caused by bad hardware, but proving it & determining which hardware has always been by biggest problem. Regards Jane --- In AccessDevelopers@yahoogroups.com, Trent Johnsey <[EMAIL PROTECTED]> wrote: > > 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 --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
