Access2016 and dbase iii

[leonardo.massei]

Hi to all,
I've just installed A2016 and I want to link to dbase_III table from VBA code:

DoCmd.TransferDatabase acLink, "dBase III", Path, acTable, Name + ".dbf", Name, False

the command fails and Access show me the message:

run-time error 2507 "dbase III non è tra i tipi di database installati o non supporta l'operazione scelta"
(dbase III is not among the types of databases installed or does not support the selected operation)

Why ? Is it possible into A2016 connect to a dbase table from VBA ?

Best Regards
Leonard

 

[Minty]

It was removed but is coming back I think; https://redmondmag.com/articles/2016/09/07/microsoft-access-supports-dbase-database.aspx

 

[jdraw]

I think this was recently reintroduced to Access under certain plans.
Here's a link to more info. re Access 2016 and dBase


Oooops: Minty is fast!

 

[leonardo.massei]

I think this was recently reintroduced to Access under certain plans.


Oooops: Minty is fast!

Hi,
thanks for your reply; so which is the solution of my problem ? Must I get Office 365 ? Can I use a different VBA command ?

Regards
Leonard

 

[Minty]

According to the comments in JDraws link you may need to do a forced update of 2016. It's something Microsoft must do - nothing we can help you with. Unless you want to go to office 365.

Have a google.

 

[leonardo.massei]

According to the comments in JDraws link you may need to do a forced update of 2016. It's something Microsoft must do - nothing we can help you with. Unless you want to go to office 365.

Have a google.

Hi,
thanks I've resolved . I've made an update of A2016 (File->Account->Updating_options) and now the VBA command works fine; futhermore I see "File dBASE" import icon when i select the "External data" tab (under "Others").

Regards
Leonard

 

[jdraw]

Leonard
Thanks for posting your solution. I'm sure others will find it helpful.