error: JAVA_HOME cannot be determined from the Registry

Hi
I am trying to export multiple dataframes from R to MS Access using the ImportExport package. I get "error: JAVA_HOME cannot be determined from the Registry"
I think this may be related to whether my Rstudio and/or R is 32 or 64 bit.

How can I tell if my Rstudio/R is 32 bit or 64 bit plz?
Will getting 64 bit Jva fix this problem?
Thanks

> access_export("DBenrich.mdb",Dfr,Dfr)
Error in access_export("DBenrich.mdb", Dfr, Dfr) : 
  could not find function "access_export"
> ImportExport::access_export("DBenrich.mdb",Dfr,Dfr)
Error: .onLoad failed in loadNamespace() for 'rJava', details:
  call: fun(libname, pkgname)
  error: JAVA_HOME cannot be determined from the Registry
> install.packages("rJava", lib="C:/Program Files/R/R-3.4.3/library")
trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.4/rJava_0.9-10.zip'
Content type 'application/zip' length 726859 bytes (709 KB)
downloaded 709 KB

package ‘rJava’ successfully unpacked and MD5 sums checked

The downloaded binary packages are in
> ImportExport::access_export("DBenrich.mdb",Dfr,Dfr)
Error: .onLoad failed in loadNamespace() for 'rJava', details:
  call: fun(libname, pkgname)
  error: JAVA_HOME cannot be determined from the Registry

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.