CODEWITHSUNDEEP
djangoms-access
user5359735
user5359735

Reputation:

Is it possible to use Django with an Access database?

Is it possible to use a Microsoft Access database (.accdb) as the back-end for a Django application?

Upvotes: 6

Views: 8639

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123689

It might be possible, at least under Windows. The Django documentation contains a link to django-pyodbc, a third-party ODBC back-end that is based on pyodbc, so perhaps you could try using that with the Access ODBC driver for Windows. However, django-pyodbc appears to be coded specifically for Microsoft SQL Server, and the SQL dialects for SQL Server ("T-SQL") and Access ("Access SQL") are similar but not identical, so compatibility with Access SQL may be somewhat limited.

Also, the question remains as to whether it is a good idea to use an Access database as a back-end for a Django application. The answer to that question is "Probably not.". An Access database is generally not a good choice of back-end for a web application. In fact, Microsoft strongly recommends against using Access in web applications.

Upvotes: 9

Related Questions