All geek questions in one place

Microsoft Access 2007 Database on Django?

I have a Microsoft Access 2007 database (.accdb) used in CRM and would really like to create an unmanaged model in django to access data (read-only) for a fast and dirty web application.

What are my options here? I looked at django-pyodbc, but they unfortunately only support ms sql connections at this time. This made me think, maybe there is a way to reflect the Microsoft Access database on the MS SQL server through ODBC, and then connect to it through the django-mssql or django-pyodbc application?

Another option is to convert the access database to some intermediate database file that can be accessed through django. The downfall of this approach is that I will need to ensure that this intermediate database is regularly synchronized with the access database, so the intermediate db is updated.

Does anyone have any ideas on how I can connect to Access 2007 CRM data through django?

+3
source share
1 answer

Access to files really does not like when someone touches them. You outgrew them. Get the correct multiuser network database and browse to it. Microsoft will sell you SQL Server for the price of a small yacht or provide you with SQL Express for free in the hope that you will need to upgrade soon.

PostgreSQL ODBC . , .

+2

Source: https://habr.com/ru/post/1796073/

More articles:


All Articles