Dan Waters
dwaters at usinternet.com
Sun Nov 1 16:12:07 CST 2009
Hi Stuart, You didn't mention if your system runs on a LAN or a WAN. If you're on a LAN, then ODBC table links and DAO will work just fine, and that is a very simple change. However, if this system is on a WAN, then using ODBC table links, and therefore DAO, will be extremely slow for remote users. In this case you might want to upsize to an ADP. But again, you don't have to - you can use continue to use an MDB. Here you should probably do a search on 'Access MDB vs. ADP'. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Sunday, November 01, 2009 3:51 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Migrating an existing linked FE-BE Access DB to SQL Server-best method? 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com