Because of the need to test the connectivity of the database, the test project uses "convenient" access to use as a background database, but because it is too "convenient", so that half a day of time is buried in its hidden keywords ...
The project uses NHibernate as the middle tier of the database and uses NUnit for unit testing. But after I have configured all the model classes and configuration files, the test environment throws this error:
nhibernate.hibernateexception: Field definition syntax error.
----> System.Data.OleDb.OleDbException: Field definition syntax error.
Hence the internet search, preliminary judgment for access keyword conflict, because the previous project because of database keyword conflicts have such a problem, so the model design process has been noticed and avoided it, but, seemingly have slipped through, and then search access to the keyword list, a field of a field comparison, No conflicts were found.
Helpless can only come up with the last resort, a field of a field to modify, and finally after n hours, found a keyword list does not exist keywords: Position
As for the conclusion, I don't want to comment on access any more, just say, I deserved it with access ...