DBU Access code

Until Access 2000, Access was designed mainly to use with its own JET database. Some concessions to bigger SQL databases were made with linked tables and ODBC through SQL pass-through queries, but there was no native support for ADO. This has made access to advanced features in SQL Server quite difficult.

Our code snippets concentrate on using Access 2/97/2000/XP/2003 to manipulate and return data through:

SQL pass-through and SQL stored procedures with parameters
ADO to DAO conversion
DAO direct

Access 2: notes on interfacing to SQL Server

How do you get at SQL from Access 2? our Access 2 page gives details.

Access 2 SQL pass-through with parameters and stored procedures

A very simple method is shown in Access 2 sp's. One proviso: because the Access querydef will be changed dynamically, only use this process if each user has the front-end Access database on their local machine.

Location Map

Updates

Access

DBU Access code

Access 2: notes on interfacing to SQL Server

Access 2 SQL pass-through with parameters and stored procedures

Copyright DBU 2000. Last updated 24 May 2004

Copyright DBU 2000.
Last updated 24 May 2004