Access

SQLServerCentral Article

Digging Into Access Performance

  • Article

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2006-01-02

8,196 reads

Technical Article

Consume Web Service from Access

  • Article

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-12-21

2,821 reads

Technical Article

How to Pass Access Data Across the Web

  • Article

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?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-05-11

3,113 reads

Technical Article

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

  • Article

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2005-02-25

1,724 reads

SQLServerCentral Article

Access to SQL Server: Getting Started with Access Projects

  • Article

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2005-02-24

10,047 reads

Blogs

Flyway Tips: More Object History

By

I wrote about Flyway Desktop Object History in a previous tip. This feature has...

Why Ai Agents need an eval framework

By

AgentDBA (the database agent I have been building) has more than 1000 automated tests,...

A New Word: Semaphorism

By

semaphorism – n. a conversational hint that you have something personal to say on...

Read the latest Blogs

Forums

Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Server-level Roles

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance

Tracking Inserted, Updated, and Deleted Rows with SQL Server OUTPUT

By Imran2629

Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...

Visit the forum

Question of the Day

Server-level Roles

In SQL Server 2025, can I alter a fixed server role?

See possible answers