Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the connection of Access database". In the daily operation, I believe that many people have doubts about the connection of Access database. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "connection of Access database". Next, please follow the editor to study!

The connection to the Access database is different in version 2000 and 2007. The connection string for Access2000 is:

Str.Format (TEXT ("Provider=Microsoft.Jet.OLEDB.4.0; Persist Security Info=False; Data Source=%s"), szDatabase); / / Database file name

Access2007 is a little different. The connection string is:

Str.Format (TEXT ("Provider=MSDASQL.1; Persist Security Info=False; Data Source=MS Access Database; Initial Catalog=%s"), szDatabase); / / Database file name

If you use the string of Access2007 to concatenate the string of Access2000, it cannot be concatenated. On the contrary, it can.

At the same time, we should pay attention to whether the driver of Access2000 is correct. 64-bit systems, usually 64 drivers, can be viewed in the administrative tool ODBC data source. If a 32-bit program runs on a 64-bit platform, a 32-bit driver must be installed.

Download and install Microsoft AccessDatabaseEngine 2010 Redistributable (28MB), there are two versions: 32bit (download) and 64bit (download). Which one to install depends on whether your Office program is 32bit or 64bit, for example: my PC is 64bit's Win8 Pro, but my Office program is 32bit, so I should install AccessDatabaseEngine.exe (32bit)

At this point, the study of "connection to Access database" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.