odbc
odbc copied to clipboard
DBI::dBDisconnect() with ms-access
After run the dbDisconnect with a ms-access connection for the first time in a session ever works well. But when call the connection again it not work more and don't finde the same table used before. If restart r session ever back works fine. I need run several script in different ms access db's. With other databases works well the disconnect and reconnect. I'm looking for a same to solution it and I using callr::r(function() function) to run the func that have the query but it's not an elegant way to fix it. Please someone could help me? Thanks.
Thanks for the issue, @c13c83. Can you please provide a minimal reprex (reproducible example), including the output of dbGetInfo()
for your connection? A reprex will help me troubleshoot and fix your issue more quickly.🙂