'Could not retrieve schema information for table or view' error in VS 2017 - M Access 2016
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 :)
- How does paging on a web page work?
- Run sql file in database from terminal
- What is the best way to do incremental backups in MySQL?
- Is there a command to clear screen in SQLite3?
- How to write this SQL query to find each account balance?
- How to add multiple columns in AWS redshift with alter table query
- Autoincrement separately for each foreign key
- How should international geographical addresses be stored in a relational database?
- MySQL union - alias not visible
- How to index a non unique key in mongodb?
- User registration with CodeIgniter
- select multiple cells inner join one table
- Split a string with no delimiters into columns
- How to submit a form that is the result of an XMLHttpRequest inside an empty div, without page refresh?
- "FATAL: remaining connection slots are reserved for non-replication superuser connections" triggers despite closing connections
- "Unsupported OP_QUERY command: insert" in Elixir project when trying to insert into Mongo DB
- Sql Server ldf files growing very fast
- How do I change the timezone to UTC in postgres permanently?
- What performance gains can I expect from database paging?
- Model.create is not a function - strapi
- Unable to copy or move file from databases folder with RNFS in react native
- Android Unit Tests Requiring Context
- Delphi FireDAC with MS Access 2010 database. Why does it convert ACE to Jet?
- database - flattened out vs. normalized
- Extract dirname from full path stored in database
- How to find a string inside a entire database?
- Implementing result paging in hibernate (getting total number of rows)
- Options to enforce a logical constraint in an Oracle database
- How can I tell a database to only return data in discrete portions?
- Where is the boundary for creating a table with types in the database?