[AccessD] Cannot export to RTF from Access2007

Thanks Rocky.

I talked (!) to Microsoft last night and the database seems to be corrupted 
in some way that's only showing up in the compiled version running in 2007. 
I converted the 2000 database to 2002-2003 and compiled that (all on the 
Vista machine), and it now appears to be exporting to Word without crashing.

However, when I imported all the 2000 version database objects to a new 2000 
database and converted that to 2002-2003 on my XP machine, the compiled 
version will not work in 2007 on the Vista machine.   So, I'm still working 
trying to understand what's going on and make sure I have a true working 
version.

I was surprised to find out this is a corruption issue.


Carolyn Johnson


----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Thursday, September 27, 2007 11:54 PM
Subject: Re: [AccessD] Cannot export to RTF from Access2007


>I have encountered differences between mdbs and mdes on A2K3 and WXP where
> the mdb would run and the mde would fail.
>
> The only way I was able to trace it down was to put message boxes in the
> code after every line - MsgBox "Point 1", MsgBox "Point 2", MsgBox "Point
> 3", etc.  Eventually I found a problem in the code that DIDN'T (!) raise 
> an
> error in the mdb but failed in the mde.
>
> Access.  Ya gotta love it.
>
> Not much help I know but that's my only experience with this.
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Carolyn Johnson
> Sent: Thursday, September 27, 2007 7:26 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Cannot export to RTF from Access2007
>
> I have a compiled Access2000 database running on Vista/Access2007.
>
> When I try to export any report to RTF, I get an error that Access is
> shutting down.    On a second computer running Vista/Access2007, I get the
> error "Object variable or With block variable not set".  (Not sure why 
> there
> are different responses.)
>
> Non-compiled version of the database exports without an error on
> Vista/Access2007 machine.
>
> Either compiled or non-compiled database on the same computer in 
> Access2003
> exports fine.
>
> Either compiled or non-compiled database on a WindowsXP/Access2000 machine
> exports fine.
>
> Unfortunately, I don't have Access2007 on a non-Vista computer at the
> moment.
>
>
> Does anyone have any experience with this?
>
>
> TIA,
> Carolyn Johnson
>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.488 / Virus Database: 269.13.32/1033 - Release Date: 
> 9/27/2007
> 11:06 AM
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com