Previous Thread

8/3/2006 4:25:02 PM    Access 97 Front End with SQL Server 2000/2005 Backend
Hi Guys/Gals 
 
I am trying to start the planning of a project that will take our Access 97 
 
Application and upsize it to a .Net Web Application and SQL Server Backend. 
 
I am proposing that we upgrade the backends and link out existing 
 
application to the new SQL Server. Then build the new Frontend. 
 
Has anybody linked an Access Frontend 97 through ODBC? Any advice, tips or 
 
results (Performance etc)? We have been using the SSW Upsizing Pro for the 
 
conversion but I am in the dark with how the Frontend with perform linked in 
 
this manner. 
 
Will I have to change any DAO code throughout the app? Or will the ODBC API 
 
take care of everything? I would rather not put any work into the current 
 
Frontend and get a start on the .Net Application. 
 
Any ideas will be greatly appreciated!



8/3/2006 5:13:13 PM    Re: Access 97 Front End with SQL Server 2000/2005 Backend
Linked tables is a Jet(Access storage engine) feature that cause Jet to 
 
direct the calls to an ODBC source. In most cases, DAO code  keeps working 
 
un modified(there are few exceptions). Typical, you may hit Performance 
 
issues  in some of the queries. Then you may want to move them to a 
 
pass-thru queries 
 
or to a view on the remote server and to link the front end to this view. We 
 
are about to publish a white paper shortly on this topic in SQL Server 
 
migration web site. 
 
Gil Lapid Shafriri 
 
Program Manager 
 
SQL Server Migration Assistant 
 
Microsoft 
 
425-7054487 
 
http://www.microsoft.com/sql/solutions/migration/default.mspx 
 
"Rick Vooys" <RickVooys@discussions.microsoft.com> wrote in message 
 
news:0B87B922-AE1F-4872-A07B-6FFEAFFB48B0@microsoft.com...