Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DBI::dBDisconnect() with ms-access #757

Open
c13c83 opened this issue Feb 7, 2024 · 1 comment
Open

DBI::dBDisconnect() with ms-access #757

c13c83 opened this issue Feb 7, 2024 · 1 comment
Labels
msaccess Microsoft Access

Comments

@c13c83
Copy link

c13c83 commented Feb 7, 2024

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.

@krlmlr krlmlr transferred this issue from r-dbi/DBI Feb 7, 2024
@krlmlr krlmlr added the msaccess Microsoft Access label Feb 7, 2024
@simonpcouch
Copy link
Collaborator

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
msaccess Microsoft Access
Projects
None yet
Development

No branches or pull requests

3 participants