Access application sharing and access sharing

Access application sharing and access sharing

I recently developed a winform project that uses an access database. After successful development, some computers can run normally and some computers cannot read database files, at first, I thought it was a permission issue. Later, I uninstalled the installer and installed it on another drive (non-drive c). A miracle occurred and it was running normally, however, I could not install C or other disks on other computers. Later I thought it was a problem that ACCess was not installed on my computer. Later, I installed ACCESS and Microsoft Data Access Components, but it still didn't work.

Then I wrote a log and checked the log.

That is to say, it is not a problem in our system, but a problem in the data source.

Since it is a data source problem, I think it should be solved from my development environment. Therefore, my development environment is installed with 2010 access, while the runtime environment is 2007 and 2013. In fact, the difference lies in different versions. Then I had a question: If I use an access database for development, do I have to install the corresponding Office in the runtime environment? I found some information on the Internet, and later found that we do not need to install office on the client, but only need to install an ODBC data source driver. (Because SQL and oracle have been used for a long time, they are less than access. So this time I encountered a problem, although it was a little basic, but it still made me a little depressed)
However, I have installed the AccessDatabaseEngine before, but it has never been used. I still don't know why. I have found many online versions, most of which are two versions. The first one is to say, you need to install the corresponding office. In the second version, you do not need to install office, but you must install an ODBC data source driver. In fact, from the very beginning, I did not agree with the first solution, because I could not allow no users to install an office. If it was small, it would be okay, but each of them would require at least 1 GB, this is too unrealistic. So the second solution did not know what went wrong and had no clue. Later I wrote a log and reported the error "the database format cannot be recognized". accdb "" was accidentally found on the official office website. In fact, AccessDatabaseEngine also has a version, including Microsoft Access Database Engine 2007 Redistributable and Microsoft Access Database Engine 2010 Redistributable, microsoft Access Database Engine 2010 Redistributable_X64, etc. Later I downloaded a Microsoft Access Database Engine 2010 Redistributable according to my local development environment. Then the miracle finally occurred.

Although it is just basic knowledge, I hope it will be useful to everyone.