1. /// <summary>
   
2. /// 读取注册表，根据Office版本获取数据库连接字段
   
3. /// </summary>
   
4. /// <returns>数据库连接字段</returns>
   
5. private string GetConnectionString()
   
6. {
   
7.   string strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = ";
   
8. 
   
9.   RegistryKey rk = Registry.LocalMachine;
   
10.   //查询Office2003
    
11.   RegistryKey f03 = rk.OpenSubKey(@"SOFTWARE\Microsoft\Office\11.0\Access\InstallRoot");
    
12.   //查询Office2007
    
13.   RegistryKey f07 = rk.OpenSubKey(@"SOFTWARE\Microsoft\Office\12.0\Access\InstallRoot");
    
14.   //查询Office2010
    
15.   RegistryKey f10 = rk.OpenSubKey(@"SOFTWARE\Microsoft\Office\14.0\Access\InstallRoot");
    
16. 
    
17.   if (f03 != null)
    
18.   {
    
19.     strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = ";
    
20.   }
    
21.   else if (f07 != null || f10 != null)
    
22.   {
    
23.     strConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = ";
    
24.   }
    
25. 
    
26.   return strConnectionString;
    
27. }

复制代码

来源：https://www.jb51.net/article/52701.htm
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！