To work with MS Access, connect to it using ODBC. Use the same syntax as you would use for Microsoft SQL server.

Actually, it can be a bit tricky. Here's a hint if running into problems:

   put "DSNName" into connDSN       -- the name of a prefab ODBC connection DSN
   put "MyDataBase" into connDB     -- optional, if used omit the ".mdb" here!
   put empty into connUser          -- or Username, if needed
   put empty into connPass          -- or Password, if needed
   get RevOpenDatabase("odbc", connDSN, connDB, connUser, ConnPass)
   if it is not a number then       -- throw an error


  1. The first parameter is "odbc" as expected.
  2. The second parameter is the name of a pre-made ODBC DSN.
  3. The third parameter can be left blank, as the database name is in the DSN already. But if it is used (for instance for clarity), the extension must be omitted!
  4. Even if parameters 3 to 5 are optional, at least empty must be provided.

So the shortest working format is:

get RevOpenDatabase("odbc", "DSNName",,,)