[AccessD] Another assessment....2007

My last contract specifically stated the project would be done in Access 
2007 and SQL Server 2005 as the back end.  Because the client has 
procurement issues (it was never approved by the IT department) SQL Server 
wasn't purchased for the project.
ALL development was done strictly in Access 2007.  When it was time to split 
the ACCDB into a FE-BE configuration - the problems began.  Over the network 
it was slow... very slow... even with only one user connected to the BE. 
Even with a persistent connection it was slow.
As an experiment, I downsized the BE to A2000 and it speeded up 
significantly.
However, the project had a requirement that several fields would be able to 
have Rich-Text formatting.  In Access 2007, the Memo field has native RTF. 
With one ACCDB the database was fast and all the requirements worked well... 
but the tool developed would eventually have several users connect to the BE 
simultaneously.
After working exclusively with A2007 for a year - I like it.  However, I 
don't recommend it for any application where there is need to have a FE/BE 
scenario.
I did some research and there doesn't seem to be any solution for the 
slowness with the FE/BE.  Even with SQL Server 2005, there seems slowness 
will be there.

Just my experience... take it for what it's worth.
Jim
--------------------------------------------------
From: "Mark Simms" <marksimms at verizon.net>
Sent: Thursday, November 11, 2010 4:26 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
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
>