Bill Patten
bill_patten at embarqmail.com
Thu Nov 11 16:55:22 CST 2010
?Mark, I have a couple of clients doing the same as Mark slowly upgrading (?) to office 2007 or 2010. In one case it is an MDE created in 2003 and it works in 2010. I disable the ribbon and the client sees the same screen in ether 2003 or 2007 or 2010. By the way if you create the MDE in 2010 it will not open in 2003. I did have some problems with a query that referenced a public variable in the form, and a report footer text box that referenced a public variable in the report and had to create a public function(s) in a module to get around that. Both worked fine in Access 2003 but seemed to require public functions in 2010, they both are working fine now. These are both running against Sql server backend with ODBC. Bill -------------------------------------------------- From: "Dan Waters" <df.waters at comcast.net> Sent: Thursday, November 11, 2010 2:40 PM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Another assessment....2007 Hi Mark, At 2 of my customers, we have a split FE/BE configuration, and some people use 2007, and some use 2003. It's just that new PC's with updated software are rolled out on a schedule. At one customer I wasn't told that this was happening - I just got a call because the ribbon was showing up for the forms and that was a change. A 3rd customer switched all at once, and they are just fine too. I did hide the ribbon for the entire system, but then I turn it on when a report opens, and then back off when the report closes. That's all I had to do. So you might be able to get away with developing purely in Access 2003, then publish the mdb files, and let them use Access 2007. However, I don't use any MDE's so I can't comment on those. Good Luck, Dan PS - Some folks on this list have said that Access 2010 is better and 2007. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms Sent: Thursday, November 11, 2010 4:27 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Another assessment....2007 Well, when it rains, it pours up here in Philly.... now I am being asking for yet another Access application assessment and cost estimate. I think they are upgrading from AC97....but once again, they want to move to AC2007....UGHH.... Is there anything I can say of benefit for AC2007 vs. AC2003 other than the ability to use the ribbon... which of course must be toggled on and off if you want to use all of the screen real estate ? Is there even one compelling feature of AC2007 ? Is there any reason I can't develop totally in 2003/MDB and then just upsize it to AC2007 ACCDB ? The only thing I'm worried about is the "split" (MDE + MDB) front-end / back-end. Will each of these separately upsize to AC2007 ? I am worried I might have to develop in MDB, upsize, and then split. -- 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