Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 7, Access, Programming Rss

   Items 1 to 6 of 6   
 

Access to SQL Server: The Upsizing Wizard

SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server.   Read more...
By Kathi Kellenberger 2007/01/12 (first published: 2005/02/22) | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 30,079 reads

Access to SQL Server: Linking Tables

SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to   Read more...
By Kathi Kellenberger 2006/11/17 (first published: 2005/02/23) | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 42,395 reads

Access to SQL Server: Linking Tables

SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to   Read more...
By Kathi Kellenberger 2006/11/17 (first published: 2005/02/23) | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 42,395 reads

Migrating Microsoft Access Applications to SQL Server

Microsoft Access targets individual information workers and small teams that use the Microsoft Office System to track, manage, prioritize, and act upon an increasing volume of business information. The data stored in these databases rarely justifies moving to a more robust platform until the application begins expanding into departmental scenarios. When this happens, it is worthwhile to consider moving the data into a more robust platform for enhanced reliability, scalability, and greater IT control. In most cases, the data can be moved through a process called "upsizing" while the Access application front-end continues to provide information workers with access to critical data. Microsoft has created resources in the following three categories to help manage Access data in your organizations:   Read more...
By Additional Articles 2005/02/23 | Source: MSDN Communities | Category: upgrading
Rating:  Rate this |   Briefcase | 3,507 reads

Access to SQL Server: The Upsizing Wizard

SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server.   Read more...
By Kathi Kellenberger 2007/01/12 (first published: 2005/02/22) | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 30,079 reads

Upsizing the Access Database into the SQL Server

SQL Server and Access are usually linked together as Access used for applications at the beginning of their lifecycle that are later moved to SQL Server when the load gets too high or the data sizes grow. There are often cases where you may also want to use SQL Server as a backend to an Access application. But how do you get your data from Access to SQL Server? Author Dinesh Asanka brings us an overview of the various ways that you can move your Access database to SQL Server.   Read more...
By Dinesh Asanka 2005/02/21 | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 16,670 reads
   Items 1 to 6 of 6   
 
Tags
upgrading (4)