Create the local admin table

Table Of Contents

Create the local admin table #

To use the code, a local table is required in the Access database, called lclVBAuthAdmin. It can be created with the following code sample, or copied from the Feature Demo supplied by VBAuth.com.

CREATE TABLE [lclVBAuthAdmin] (
  [AppID] AUTOINCREMENT PRIMARY KEY,
  [ActionName] TEXT(255),
  [ClientID] TEXT(50),
  [TenantID] TEXT(50),
  [ObjectID] TEXT(50),
  [ScopeClaims] MEMO,
  [Verb] TEXT(255),
  [URLPart1] TEXT(255),
  [URLParameter1] TEXT(255),
  [URLPart2] TEXT(255),
  [URLParameter2] TEXT(255),
  [URLPart3] TEXT(255),
  [WaitForLogin] INTEGER DEFAULT 60
);
Code language: CSS (css)

VBAuth, developed and maintained by Andrew Richards (The IT Service Ltd) and Peter Bryant (Corylus Business Systems), © 2025–2026. All rights reserved. https://vbauth.com

Updated on September 7, 2026