Fandom

Livecode Wiki

Access

2,161pages on
this wiki
Add New Page
Comments0 Share

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

Summary:

  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",,,)

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.