Source language: Translate to:

NeoBookDBPro and MS Access ".accdb" format

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

NeoBookDBPro and MS Access ".accdb" format

Postby Leos » Thu Dec 17, 2015 4:35 pm

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

Re: NeoBookDBPro and MS Access ".accdb" format

Postby Neosoft Support » Thu Dec 17, 2015 8:24 pm

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

Re: NeoBookDBPro and MS Access ".accdb" format

Postby yanzco » Wed Jan 25, 2017 5:17 am

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..
yanzco
 
Posts: 178
Joined: Sun Jul 20, 2014 4:07 am

Re: NeoBookDBPro and MS Access ".accdb" format

Postby dpayer » Wed Jan 25, 2017 1:28 pm

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

Re: NeoBookDBPro and MS Access ".accdb" format

Postby yanzco » Wed Jan 25, 2017 10:12 pm

Oh.. How is that? Do i need to install some other plugin? Or maybe database drivers? Could guide me some steps?.. :)
yanzco
 
Posts: 178
Joined: Sun Jul 20, 2014 4:07 am

Re: NeoBookDBPro and MS Access ".accdb" format

Postby Neosoft Support » Sun Feb 05, 2017 11:35 am

You can open an existing ACCDB database like this:

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

The database was created originally with MS Access.
NeoSoft Support
Neosoft Support
NeoSoft Team
 
Posts: 5602
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: NeoBookDBPro and MS Access ".accdb" format

Postby Leos » Thu Feb 09, 2017 6:00 pm

Hi,
excuse my delay for the answer
It woks great!
Thank you
User avatar
Leos
 
Posts: 178
Joined: Mon Apr 04, 2005 11:13 am
Location: Coimbra, Portugal


Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest