NeoBookDBPro and MS Access ".accdb" format

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Locked
User avatar
Leos
Posts: 178
Joined: Mon Apr 04, 2005 11:13 am
Location: Coimbra, Portugal
Contact:

NeoBookDBPro and MS Access ".accdb" format

Post 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
Neosoft Support
NeoSoft Team
Posts: 5628
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA
Contact:

Re: NeoBookDBPro and MS Access ".accdb" format

Post 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?
NeoSoft Support
yanzco
Posts: 192
Joined: Sun Jul 20, 2014 4:07 am

Re: NeoBookDBPro and MS Access ".accdb" format

Post 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..
User avatar
dpayer
Posts: 1394
Joined: Mon Apr 11, 2005 5:55 am
Location: Iowa - USA

Re: NeoBookDBPro and MS Access ".accdb" format

Post 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.
David Payer
Des Moines, Iowa
USA
yanzco
Posts: 192
Joined: Sun Jul 20, 2014 4:07 am

Re: NeoBookDBPro and MS Access ".accdb" format

Post by yanzco »

Oh.. How is that? Do i need to install some other plugin? Or maybe database drivers? Could guide me some steps?.. :)
Neosoft Support
NeoSoft Team
Posts: 5628
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA
Contact:

Re: NeoBookDBPro and MS Access ".accdb" format

Post 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.
NeoSoft Support
User avatar
Leos
Posts: 178
Joined: Mon Apr 04, 2005 11:13 am
Location: Coimbra, Portugal
Contact:

Re: NeoBookDBPro and MS Access ".accdb" format

Post by Leos »

Hi,
excuse my delay for the answer
It woks great!
Thank you
Locked