C# The problem that the total report cannot be found when connecting Access data
”Provider=.4.0; Data Source=;”，
There is nothing at all. Later, after checking, I found that it was a problem with the schema.
There is a concept of schema in SQL Server, so we are generally used to writing it. So if you write it like this in Access, you will report problems that cannot be found above. After modifying the SQL statement and removing dbo, the problem will be solved.
Related Articles
Chinese Access2000 Quick Tutorial--1.4 Use the "Table Wizard" to create a new table
Chinese Access2000 Quick Tutorial-1.4 Use the "Table Wizard" to create a new table...2006-11-11The reason why the Access database is "cannot be saved; locked by other users" is
ACCESS' concurrency control is very bad. Remember to close the database after each operation.2009-03-03Resolve an error that was not specified by Microsoft JET Database Engine (0x80004005) in Access
When we use the access database, we sometimes encounter unspecified errors of Microsoft JET Database Engine (0x80004005). Generally, this error is a permission problem. Today we will discuss the solution in detail.2014-11-11Use INNER JOIN syntax to join multiple tables to create record sets
Use INNER JOIN syntax to connect multiple tables to create record sets...2006-07-07Access string processing function sorting
Some string processing function codes used in the access database can be used as reference.2011-05-05Use the criteria to conduct conditional query-1.3. Enter parameters before running the query
Use the criteria to conduct conditional query-1.3. Enter parameters before running the query...2006-11-11Solve the problem of grouping reports in Access
Solve the problem of grouping reports in Access...2006-11-11Chinese Access2000 Quick Tutorial-1.5 Automatically create new tables using existing data
Chinese Access2000 Quick Tutorial-1.5 Automatically create new tables using existing data...2006-11-11Escape characters about SQL statements in ACCESS
Escape characters about SQL statements in ACCESS...2007-04-04Access uses macro control programs 3. Use conditions in macros
Access uses macro control programs 3. Use conditions in macros...2006-11-11