Page 1 of 1

.accdb

PostPosted: Mon Jun 24, 2013 11:13 am
by gustavo.mejia
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"
EndIf

dbpOpenAccessDatabase "Test" "[MyDocuments]\testdb.accdb" ""
dbpTableExists "Test" "Table1" "[TableExists]"
If "[TableExists]" "<>" "True"
dbpCreateTable "Test" "Table1" "Name String(35);LastName String(35);Age Integer"
EndIf
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.

Gustavo

Re: .accdb

PostPosted: Tue Jun 25, 2013 10:47 am
by Neosoft Support
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:

http://www.microsoft.com/en-us/download/details.aspx?id=23734

Generally, it's much easier to use the .MDB format unless you specifically need .ACCDB for some reason.