Django 上的 Microsoft Access 2007 数据库？
我有一个在 CRM 中使用的 Microsoft Access 2007 数据库 (.accdb)，我非常想在 django 中创建一个非托管模型来访问数据（只读），以实现快速而肮脏的 Web 应用程序。
我在这里有什么选择？我查看了 django-pyodbc，但不幸的是它们目前仅支持 ms sql 连接。这让我想知道，也许有一种方法可以通过 ODBC 将 Microsoft Access 数据库镜像到 MS SQL 服务器，然后通过 django-mssql 或 django-pyodbc 应用程序连接到该服务器？
另一种选择是将 access 数据库转换为某个中间数据库文件，然后可以通过 django 访问该文件。这种方法的缺点是我需要确保定期将此中间数据库与访问数据库同步，以便中间数据库是最新的。
有人知道如何通过 django 连接到我的 Access 2007 CRM 数据吗？
I have a Microsoft Access 2007 database (.accdb) used in a CRM, and I'd very much like to create an unmanaged model in django to access the data (read-only) for a quick 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. That made me wonder, perhaps there is a way to mirror a Microsoft Access database to a MS SQL server through ODBC, and then connect to that through the django-mssql or django-pyodbc application?
Another option is to convert the access database to some intermediary database file which could then be accessed through django. The downfall to this approach is that I'd need to ensure that I regularly syncronize this intermediary database with the access database, so the intermediary db is up to date.
Does anyone have any ideas on how I can connect to my Access 2007 CRM data through django?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Access 文件确实不喜欢多个人接触它们。你已经超越了他们。获取适当的多用户网络数据库并迁移到该数据库。 Microsoft 将以一艘小游艇的价格向您出售 SQL Server，或者免费向您提供 SQL Express，希望您很快就需要升级。
或者通过 ODBC 永久免费使用 PostgreSQL。但是，不要在不先通过服务器的情况下尝试将文件用作数据库。
Access files really don't like more than one person touching them. You've outgrown them. Get a proper multi-user networked database and migrate to that. Microsoft will sell you SQL Server for the price of a small yacht or give you SQL Express for free in the hope that soon you'll need to upgrade.
Or use PostgreSQL via ODBC for free for ever. But don't try and use a file as a database without going through a server first.