Source language: Translate to:


Questions about our Advanced Database plug-in

Moderator: Neosoft Support


Postby gustavo.mejia » Mon Jun 24, 2013 11:13 am

I am running Neobook 5.8.4 on Windows 8 and dpp NeoBookDBpro 6.1a, which is supposed to be able to open .accbd Access databases. However, the following code gives me errors as indicated below:

FileExists "[MyDocuments]\TestDB.accdb" "[FileExists]"
If "[FileExists]" "<>" "True"
dbpCreateAccessDatabase "[MyDocuments]\TestDB.accdb" "Password=;Encrypted=No"

dbpOpenAccessDatabase "Test" "[MyDocuments]\testdb.accdb" ""
dbpTableExists "Test" "Table1" "[TableExists]"
If "[TableExists]" "<>" "True"
dbpCreateTable "Test" "Table1" "Name String(35);LastName String(35);Age Integer"
dbpOpenTable "Test" "Table1" ""

The errors generated (in sequence) are:

Class not registered
Database fie TestDB.accdb does not exist
invalid database ID

Can someone tell me what I am doing wrong? If I change the database name to .mdb, the code works fine. The plugin is properly installed (it shows a green check mark next to its name).

Thanks for any help.

Posts: 4
Joined: Fri Jun 14, 2013 9:12 pm

Re: .accdb

Postby Neosoft Support » Tue Jun 25, 2013 10:47 am

The code works with the .MDB extension because that db format uses Microsoft's Jet engine which is part of Windows. The .ACCDB db format requires the Access Connectivity Engine which is not installed by default with any version of Windows. The Access Connectivity Engine must be manually installed as part of MS Access or as a separate component. You can download the ACCDB engine from Microsoft's website below:

Generally, it's much easier to use the .MDB format unless you specifically need .ACCDB for some reason.
NeoSoft Support
Neosoft Support
NeoSoft Team
Posts: 5620
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest