[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