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

Content with tags Programming, Access Rss

   Items 1 to 20 of 23    Older >>
 

Linking Access to SQL Server

For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.   Read more...
By Andy Warren 2007/11/02 (first published: 2006/01/25) | Source: SQLServerCentral.com | Category: access
Rating: |  Discuss |   Briefcase | 26,822 reads

Browser Style Form Navigation

This article series features a demo app affectionately named Something Not Entirely Unlike Access, which employs a variety of methods to obfuscate the "Accessian" features.   Read more...
By Additional Articles 2007/09/06 | Source: Database Journal | Category: access
Rating:  Rate this |   Briefcase | 3,192 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,077 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,380 reads

Save and Retrieve Datasheet Layout with the Windows Registry

Danny Lesandrini shares a block of code that will allow users to modify (and save) datasheet layout when they are using a compiled MDE version of your Access applications.  Read more...
By Additional Articles 2006/09/01 | Source: Database Journal | Category: access
Rating:  Rate this |   Briefcase | 1,803 reads

Linking Access to SQL Server

For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.   Read more...
By Andy Warren 2007/11/02 (first published: 2006/01/25) | Source: SQLServerCentral.com | Category: access
Rating: |  Discuss |   Briefcase | 26,822 reads

Digging Into Access Performance

Access can be a very quick and easy to use tool for working with SQL Server data and for quick and dirty projects, it might be the best tool. But there can be performance issues at times and Andy Warren digs into some of these based on some analysis of what Access does behind the scenes.   Read more...
By Andy Warren 2006/01/02 | Source: SQLServerCentral.com | Category: access
Rating: |  Discuss |   Briefcase | 8,073 reads

Consume Web Service from Access

A few months ago, I posted an article here at DBJ named How to Pass Access Data Across the Web. One reader expressed concern over using the Microsoft Internet Explorer library because of security issues. While I do not share his fear, I appreciate that others might, so I began to think about how the process could be enhanced by substituting a Web Service for the traditional ASP/Querystring web page approach described in the article. What follows is the fruit of those labors.  Read more...
By Additional Articles 2005/12/21 | Source: Database Journal | Category: access
Rating:  Rate this |   Briefcase | 2,346 reads

Where does Access fit in Microsoft’s future?

Where does Access fit in Microsoft’s future? Before that question is answered, we should examine why it might be important.   Read more...
By Additional Articles 2005/11/08 | Source: Red-Gate | Category: access
Rating:  Rate this |   Briefcase | 4,914 reads

How to Pass Access Data Across the Web

The solution described below should probably not be considered a "best practice" but it works. It came to life as I was pondering the following conundrum: How can I pass a little bit of data from an internal Access application behind a firewall out to a public web site in real time?   Read more...
By Additional Articles 2005/05/11 | Source: Database Journal | Category: access
Rating:  Rate this |   Briefcase | 2,671 reads

Microsoft Access Performance FAQ

Try the following suggestions as originally suggested by Frank Miller of Microsoft PSS and extensively updated by me. Almost all of these tips also apply to Microsoft Access 97.  Read more...
By Additional Articles 2005/02/25 | Source: Other | Category: access
Rating:  Rate this |   Briefcase | 1,874 reads

Bind an Access Form's Record Source from an XML File at Runtime

Learn how to bind a form dynamically to a recordset created from an XML file. This simple application can be the starting point for a powerful solution for your customers and should be considered a part of your arsenal when developing Access application.  Read more...
By Additional Articles 2005/02/25 | Source: MSDN Communities | Category: access
Rating:  Rate this |   Briefcase | 1,403 reads

Review: Access Workbench

For some years, I have been asked to review a product that I have only just gotten around to looking at. It was developed by Garry Robinson, who publishes a very useful web resource called vb123.com and who recently wrote one of the best books on Access security, Real World Microsoft Access Database Protection and Security. The product is called The Access Workbench (TAW)   Read more...
By Additional Articles 2005/02/25 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,862 reads

Access to SQL Server: Getting Started with Access Projects

SQL Server 2000 and Access databases are two technologies closely linked with the new Access ADP format using SQL Server as the basis for the code. Access Projects are also a way to closely link the two products together and take advantage of each to produce an application very easily. Author Kathi Kellenberger brings us part 3 of her Access series with a look at Access Projects.   Read more...
By Kathi Kellenberger 2005/02/24 | Source: SQLServerCentral.com | Category: access
Rating: |  Discuss |   Briefcase | 9,946 reads

The Future of Access

Jon Sigler of Microsoft visited the Denver Access users group with some comments about where Access is going.  Read more...
By Additional Articles 2005/02/24 | Source: Database Journal | Category: access
Rating:  Rate this |   Briefcase | 2,960 reads

Working with PowerPoint Presentations from Access Using Automation

Create a PowerPoint slide presentation from scratch using Access data. In addition, display and control a slide show from within an Access form. Walk through the solution and explore ways to extend the sample for your own applications.  Read more...
By Additional Articles 2005/02/23 | Source: MSDN Communities | Category: access
Rating:  Rate this |   Briefcase | 1,452 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,496 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,380 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,077 reads

Performance Tuning Tips for Using Microsoft Access

If you are really interested in the fastest performance, don't use Access as a front-end to a SQL Server database. While Access is relatively easy to learn and fast to develop in, its performance if poor when compared to other front-end options. But if you like to develop in Access, or don't have any choice, then the tips on this page will help a little to boost your application's performance.   Read more...
By Additional Articles 2005/02/22 | Source: SQL Server Performance | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,669 reads
   Items 1 to 20 of 23    Older >>
 
Tags
sql server 7 (4)    
upgrading (4)    
miscellaneous (2)    
product reviews (1)    
reviews (1)