Updating linked tables in access catchy opening lines for dating sites

In Access, the tables appear with a "linked" icon, which is a globe with an arrow pointing to it.

When you open a table in Access, the data is retrieved using a keyset cursor.

updating linked tables in access-31

Andy Baron November 2006 Applies to: Microsoft SQL Server 2005 Summary: One way to create applications that use Microsoft Office Access for creating user interfaces and that use Microsoft SQL Server for data storage is to link Office Access tables to SQL Server tables.

This is the type of application created by using the SQL Server Migration Assistant for Office Access.

This white paper presents techniques for improving performance and updatability in Office Access applications that use tables linked to SQL Server.

(22 printed pages) Click here for the Word version of this article.

Developers often migrate data to SQL Server expecting an improvement in application performance.

Although performance does often improve, there are many cases where it remains the same or even degrades.

This white paper discusses several of these issues and presents strategies for resolving them.

Most of these issues relate to performance or updatability.

Migrating Access Databases to SQL Server Note The feedback system for this content will be changing soon. If content within a comment thread is important to you, please save a copy.

Tags: , ,