[AccessD] 2000 vs 97 - trim error

Kathryn Bassett kathryn at bassett.net
Sat Mar 12 23:01:18 CST 2005


No recompile because I didn't use any macros etc so didn't think about it. Too late to do it in 2k as she's now making changed in 97 version. So, what menu and command needs to be one on the 97 version to "compile" it?

--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net    

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> MartyConnelly
> Sent: 12 Mar 2005 4:58 pm
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] 2000 vs 97 - trim error
> 
> I opened up the 97 version mdb, reports are okay on my 
> machine I am running WinXP Home Access 97 SR-2 and Jet SP 8 
> It could be Service Packs or did you remember to do a full 
> recompile of 2000 before converting to 97
> 
> 
> Kathryn Bassett wrote:
> 
> >Friend has Access97, and the data she's been using for a 
> couple years now has been working fine. She received a new 
> grouping of people, so I brought her 97 home, opened with 2k, 
> imported and set up the new table (members), made a query and 
> set up one of the reports. Everything working fine in 2k. Did 
> the save to previous version, went to her house and put back 
> on computer. Queries and forms work fine, but when I tried to 
> do reports, the all give me this trim error.
> >http://www.ourwebsite.org/storage/misc/trimerror1.jpg and 
> here is what 
> >the design view looks like 
> >http://www.ourwebsite.org/storage/misc/trimerror2.jpg
> >
> >All the reports are similar, and give the same error, even 
> though I never touched them. So it must be something about 
> taking from 97 to 2k and back again that messed things up. 
> What's wrong and how do I fix?
> >
> >If you need to see the actual mdb, I've zipped both versions 
> and put them here:
> >http://www.ourwebsite.org/storage/misc/pgch.zip
> >
> >Thanks,
> >
> >--
> >Kathryn Rhinehart Bassett (Pasadena CA) "Genealogy is my 
> bag" "GH is my 
> >soap"
> >kathryn at bassett.net
> >http://bassett.net   
> >
> >  
> >
> 
> --
> Marty Connelly
> Victoria, B.C.
> Canada
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com




More information about the AccessD mailing list