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