Stuart McLachlan
stuart at lexacorp.com.pg
Sun Nov 1 15:51:29 CST 2009
No doubt the authors will chip in here, since they are regulars on this list. :-) My answer: You certainly don't HAVE to. In many situations, there is no need to. I have a large number of Access FEs that use ODBC to link to SQL Server BEs. All using DAO. The Upsiziing Wiizard will basically do that for you. You can then assess the the performance and where necessary convert existing queries to SQL Views to improve performance. FWIW, I avoid ADPs like the plague. -- Stuart On 1 Nov 2009 at 11:58, FRANCIS ALWARD wrote: > Hello All, > > I want to upgrade an existing Access DB to SQL Server with an Access > user interface. Just bought "SQL:Access to SQL Server" by Harkins and > Reid. They recommend creating an ADP, to "achieve the full benefits" > of SQL Server. > > My question: for an existing Access FE-BE DB, should I (must I?) > re-work it as a stand-alone DB, and try to re-write all the DAO code > in ADO, before proceeding with the Upsizing Wizard? > > I'm an amateur programmer, but have been supporting a multi-user > commercial DB that needs to be upsized. > > Thanks, > JA > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >