R Session Aborted due to 32bit Access Connection using RODBC

Question

I am trying to connect to a 32bit access using R lang 4.1.3 32bit using the following code chunk,

library(RODBC)
db_path <- "C:/Pathway/To/Access.accdb
con <- odbcConnectAccess2007(db_path)

when running that chunk I have a critical failure and get the R Session Aborted window.

Is there any advice on how to fix this?

RODBC has some issues. If it isn't a major rework, I recommend DBI + odbc, see [this answer](https://stackoverflow.com/a/62433795/7296893) — Erik A, Feb 15 '23 at 10:41

score 0 · Answer 1 · answered Feb 14 '23 at 21:02

0

Try without the typos:

library(RODBC)
db_path <- "C:/Pathway/To/Access.accdb"
con <- odbcConnectAccess2007(db_path)

And/or study here:

answered Feb 14 '23 at 21:02

Gustav

Typos fixed, previously working and seems to stop with an update. Was hoping someone else has encountered this. It is being run in a 32bit environment so that link doesn't provide much insight. – a nony mouse Feb 14 '23 at 21:07

1 Answers1