odbc icon indicating copy to clipboard operation
odbc copied to clipboard

DBI::dBDisconnect() with ms-access

Open c13c83 opened this issue 1 year ago • 1 comments

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.

c13c83 avatar Feb 07 '24 13:02 c13c83

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.🙂

simonpcouch avatar Feb 07 '24 16:02 simonpcouch