MS Access

Your Microsoft Access database files are cached on our server. A direct remote connection to the file is not possible. While you can make your MS Access table editable within WordPress, changes cannot be written back to the original database file.

Each remote table requires its own configuration in WP Data Access. To prevent multiple uploads of the same MS Access file, the plugin automatically detects when multiple tables use the same source file. This reduces download overhead for updates and ensures all related tables remain in sync.

📌 To use the remote connection wizard, you must first enable our Premium Data Service on your WordPress server.

PREPARATION

Ensure your MS Access file is available at a public URL before starting the remote connection wizard. Test your public URL to confirm it is accessible. (read more…)

CREATION

1. Start the Data Explorer.
2. Click the connect icon to open the remote connection wizard.
3. Select Microsoft Access ACCDB or Microsoft Access MDB from the connection type drop-down list.
4. Fill out the remote database and remote file sections.
5. Leave the username and password fields blank if your database file does not require them.
6. Enter the public URL of your data file in the file path field.
7. Define an update interval, or leave it blank if automatic updates are not required.
8. Enter a table name.
9. Click the create button.

USAGE

• MS Access tables can be used just like standard WordPress tables and are supported by all plugin tools.
• A primary key is required for data management and must be explicitly defined in WP Data Access.
• Modifications made within WP Data Access are not written back to the original MS Access file.
• Read the limitations before you start.