VS 2017 - M Access 2016 中的“无法检索表或视图的架构信息"错误 [英] 'Could not retrieve schema information for table or view' error in VS 2017 - M Access 2016

问题描述

我正在尝试将我的 Visual Studio 项目连接到我机器上本地的 Microsoft Access 数据库，我能够在 Microsoft Access 中正确打开数据库，我什至尝试让它没有记录并且尽可能简单，当我在 Visual Studio 中添加它并且当我测试连接时它说 Test connection succeeded，它向我显示数据库，它可以找到包含所有字段的表名，但是当我点击完成我收到一条错误消息:

<块引用>

无法检索表或视图 [数据库表名] 的架构信息

我搜索了很多，我看到了

当本应比使用 MySQL 和 PHP 来控制在线数据库的问题比使用本地数据库和 Microsoft Access 更容易解决时，我真的觉得这很有趣.

希望这能解决有同样问题的人:)

I'm trying to connect my Visual Studio project to a Microsoft Access database locally on my machine, I'm able to open the database correctly in Microsoft Access and I even tried making it empty of records and as simple as possible, when I'm adding it in Visual Studio and when I test the connection it says Test connection succeeded, and it's showing me the database, it can find the table name with all the fields, but when I hit finish I get an error message saying :

Could not retrieve schema information for table or view [database table name]

I'v searched a lot and I'v seen this post on StackOverflow but it did't help. I'm still getting that error, and this is a short clip on what's happening.

Can someone please help me here!

解决方案

I finally figured it out, I opened the Visual Studio Installer and I downloaded and installed the SQL Server Package and then tried and it worked just fine.

Knowing that I tried installing the SQL Server 2017 using a stand-alone installation but it didn't work, so you need to install it form the same Visual Studio Installer.

Here is an image of that :

I really find it fascinating when the things that supposed to be harder than other things like problems using MySQL with PHP to control an online Databases is easier to solve than using a local databases and Microsoft Access.

Hope this solves someone that has the same problem :)

这篇关于VS 2017 - M Access 2016 中的“无法检索表或视图的架构信息"错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！