Hi Trent As you predicted the problems are down to network problems. The IT company have been to look at the server & have said that it's completely overloaded. It's a few years old now & can't cope with the load. So they should be getting a new server soon & the problems should go!! Thanks for your help. I felt sure it was hardware, but just needed someone else to say the same. 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 --------------------~--> 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/
