#🔒 What's a free alternative to MS access that can interact with pyodbc?

6 messages · Page 1 of 1 (latest)

empty crane
#

I've been tasked with writing a program that can interact with a microsoft access database, but I can't run microsoft access on my development machine. I had the idea of using Libreoffice Base, but I can't find pyodbc drivers for that. What is the easiest-to-use alternative to Microsoft Access that can interact with pyodbc in a way where, if there would be an error with microsoft access, then there would also be an error with the other db?

calm basinBOT
#

@empty crane

Python help channel opened

Remember to:

  • Ask your Python question, not if you can ask or if there's an expert who can help.
  • Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
  • Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.
empty crane
#

Looks like actually the easiest thing would be to have a .mdb file, and then open that using odbc in libreoffice to monitor it.

empty crane
#

Nope, I can't add a table to a microsoft access database thru libreoffice base. Still need help here.

calm basinBOT
#

@empty crane

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.