Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Tue Nov 11 10:16:15 CST 2003
Tried. No soap. Rocky ----- Original Message ----- From: "Joe Hecht" <jmhla at earthlink.net> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Tuesday, November 11, 2003 7:59 AM Subject: RE: [AccessD] Another Hosed Database Trying again. > > Can you export the tables into a new BE. Try one table at a time to help > you identify where the problem is. > > It has helped me once or twice. > > Joe Hecht > Los Angeles CA > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > - Beach Access Software > Sent: Monday, November 10, 2003 3:17 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Another Hosed Database > > > "Maybe they got that message and didn't tell you..." > > I suppose that could possibly happen. :) > > Compact didn't help. I even put it through the decompile even though > there was no code, just a shot in the dark.. no soap. > > They were able to print out all of the data entered since their last > backup, and restore that backup and are now going to re-enter the data, > and hopefully they'll be a little more rigorous in the future about > making and verifying backups. > > Rocky > > ----- Original Message ----- > From: "David McAfee" <DMcAfee at haascnc.com> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Monday, November 10, 2003 1:38 PM > Subject: RE: [AccessD] Another Hosed Database > > > > Rocky, can you compact the db? Maybe it has corrupted records. Usually > > > if > its bad enough, you will get an error massage stating "you and another > user are attempting to view the same record..." and leave you with an > uncompacted mdb and a new db1.mdb. Maybe they got that message and > didn't tell you when they repaired the mdb? > > > > David > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin > > > - Beach Access Software > > Sent: Monday, November 10, 2003 12:34 PM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Another Hosed Database > > > > > > Charlotte: > > > > Hey - this is the kind of client that pays the rent. Anyway, it's not > > > in the query (which is in the front end) because when I restore an > > older copy of their BE db the FE works just fine. > > > > Since my first post I have determined that there is a parent record > > (agreement header) missing in the header table which has 4 child > > records (agreement details) in the detail table. FK in those child > > records points to a non-existent PK in the parent table). > > > > So I think the repair didn't. But on the surface, the orphan child > records > > alone should not product the result they're getting. OTOH, it points > > to other possible problems in the BE. > > > > Rocky > > > > ----- Original Message ----- > > From: "Charlotte Foust" <cfoust at infostatsystems.com> > > To: "Access Developers discussion and problem solving" > > <accessd at databaseadvisors.com> > > Sent: Monday, November 10, 2003 12:02 PM > > Subject: RE: [AccessD] Another Hosed Database > > > > > > > Rocky, > > > > > > You've GOT to get some different clients! LOL > > > > > > What version of Access and have you tried building a new query? > > > > > > Charlotte Foust > > > > > > -----Original Message----- > > > From: Rocky Smolin - Beach Access Software > > > [mailto:bchacc at san.rr.com] > > > Sent: Monday, November 10, 2003 11:50 AM > > > To: AccessD at databaseadvisors.com > > > Subject: [AccessD] Another Hosed Database > > > > > > > > > Dear List: > > > > > > A client of mine has a database which got corrupted. I told them to > > > > open the back end directly and they got the message which said > > > database appears to be corrupted would you like to attempt repair, > > > which they did and it appeared to go OK. > > > > > > However, apparently all is not well, because when I try to add a > > > record to a detail file - bound form, subform on a tab - the command > > > > DoCmd.GoToRecord ,,acNewRec blows up with 'Can't go to specified > > > record'. > > > > > > When I run the query that is the record source for the subform, it > > > does indeed not allow additions. > > > > > > When I do the same thing on an older copy of their database > > > everything works OK. So I know it's not in the front end. > > > > > > Can this db be saved? > > > > > > MTIA, > > > > > > Rocky Smolin > > > Beach Access Software > > > > > > P.S. Yes they have a backup but no it's not recent. Apparently the > > > person responsible for backup up...didn't. > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >