Microsoft Access

This extension contains functions for displaying data from Microsoft Access databases.  Related Links: Extension Overview, DekiScript Overview, Extension Demos.

Assembly: mindtouch.access
SID: sid://mindtouch.com/ent/2008/06/microsoft.access
License: Enterprise

This service requires Deki Wiki 8.08 or later.

To enable this extension, follow these steps:

1. Go to Service management in the Control Panel of your wiki.
2. Under Add Service, click on Local, and select type Extension.
3. Enter a description and the extension SID: sid://mindtouch.com/ent/2008/06/microsoft.access
4. Add any additional configuration settings that are required by the extension (see below).
5. Click on add service.

Configuration:

Before the Microsoft Access extension can be used, it must be configured with the access information to the database.

If you need to configure multiple databases for the same wiki, register this extension once for each database.  Use the following preference to specify a unique namespace value for each registration.  Invoke the service using this value instead of access.  For example, if you set namespace=mydb1, you would invoke the service with mydb1.table("...") instead of access.table("...").

NOTE: The folder in which the Microsoft Access database resides must have appropriate rights granted, otherwise you will receive a "Could not create lock file" error.

Functions:

Access.Table(query : str) : xml

Show results of a SELECT query in a sortable table.

Parameters:

Name	Type	Description
query	str	SELECT query.

Samples:

	Output
To embed a SELECT query that displays a list of all users in the users table: {{ access.table("SELECT user_name as Name, user_email as Email FROM users") }}

---