This project has moved. For the latest updates, please go here.
1
Vote

Couldn't create Access DB

description

I just followed the tutorial https://www.youtube.com/watch?v=mI0un8jjqL8. but I met this issue.
Image. How to deal with it?

file attachments

comments

bubibubi wrote Feb 17 at 6:44 AM

Some tries:
1) Are you using Microsoft Access 32 bits? Microsoft Access install ACE OleDB drivers for access to the accdb file. Actually EF provider is compiled as 32 bit library so you need to have the 32 bits ACE OleDB so you need to have Microsoft Access 32 bits.
2) Could you open the database without using EF (i.e. using only ADO)?
3) Could you send your App Config

lampon wrote Feb 17 at 3:32 PM

Thanks a lot. The previous problem I have solved. The problem is that I was using Microsoft Access 64 bit. But I met new issue. I try to use Migration to create Access DB on my project. It worked on my project 1 which was generated by ConsoleApplication. But It didn't work on my project 2 which was generated by Winform. That was so strange! I'm pretty sure the Model is the same, And the script for creating Access DB is the same too.

Output on project 1:
Image

Output on project 2:(Some chinese character in the picture mean 'Counld not found table or constraint' )
Image

The same Script for creating Database:
Image