Page 1 of 1

NeoBookDBPro and MS Access ".accdb" format

PostPosted: Thu Dec 17, 2015 4:35 pm
by Leos
Hi,
Is there any possibility to consider an update to NeoBookDBPro compatible with the new access database format "*.accdb"
( I can obviously consider to NOT be free )

Thanks

Re: NeoBookDBPro and MS Access ".accdb" format

PostPosted: Thu Dec 17, 2015 8:24 pm
by Neosoft Support
Technically DBPro is database agnostic. It knows very little about the database engine you're using whether it's MS Access, mySql, etc. DBPro interacts with each engine via the ADO/ODBC interface. So if you have an ODBC driver for a database installed you should be able to use it with DBPro. You may have to figure out what the correct connection string is, but once you do it should work.

DBPro's dbpOpenAccessDatabase action should already be able to open .accdb format files. (Unless Microsoft recently changed something.) Have you tried it?

Re: NeoBookDBPro and MS Access ".accdb" format

PostPosted: Wed Jan 25, 2017 5:17 am
by yanzco
ive been sticking with .mdb ever since,,
and recently creating a new database, trying it out to see if it is supported by now..
but, it says, unknown databasefile type...

so i guess, .accdb is not supported..

Re: NeoBookDBPro and MS Access ".accdb" format

PostPosted: Wed Jan 25, 2017 1:28 pm
by dpayer
yanzco wrote:ive been sticking with .mdb ever since,,
and recently creating a new database, trying it out to see if it is supported by now..
but, it says, unknown databasefile type...

so i guess, .accdb is not supported..



Not true. .accdb is simply the newer version of Access. .mdb is the older version

You can use it easily, either with direct access or using ODBC.

Re: NeoBookDBPro and MS Access ".accdb" format

PostPosted: Wed Jan 25, 2017 10:12 pm
by yanzco
Oh.. How is that? Do i need to install some other plugin? Or maybe database drivers? Could guide me some steps?.. :)

Re: NeoBookDBPro and MS Access ".accdb" format

PostPosted: Sun Feb 05, 2017 11:35 am
by Neosoft Support
You can open an existing ACCDB database like this:

dbpOpenAccessDatabase "MyDB" "[PubDir]Database.accdb" ""

The database was created originally with MS Access.

Re: NeoBookDBPro and MS Access ".accdb" format

PostPosted: Thu Feb 09, 2017 6:00 pm
by Leos
Hi,
excuse my delay for the answer
It woks great!
Thank you