MS Access数据库的Vb.net连接字符串 [英] Vb.net Connection String for Ms Access Database

问题描述

在VB.net中用于连接MS Access 2010(.accdb)数据库的连接字符串是什么.

What is the connection string for connecting MS Access 2010 (.accdb) database in VB.net.

推荐答案

connectionstrings.com是很棒的事情:

connectionstrings.com is a wonderful thing:

标准安全性

Provider = Microsoft.ACE.OLEDB.12.0;数据 源= C:\ myFolder \ myAccess2007file.accdb;持久安全信息= False;

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;

使用数据库密码

这是您具有Access 2007时要使用的连接字符串 使用设置数据库密码"使用密码保护数据库 在Access中起作用.

This is the connection string to use when you have an Access 2007 database protected with a password using the "Set Database Password" function in Access.

Provider = Microsoft.ACE.OLEDB.12.0;数据 源= C:\ myFolder \ myAccess2007file.accdb; Jet OLEDB:数据库 密码= MyDbPassword;

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;

一些关于密码长度超过14个字符的问题的报告.还 某些字符可能会引起麻烦.如果有问题 尝试将密码更改为带有普通字符的简短密码.

Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.

DataDirectory功能

Provider = Microsoft.ACE.OLEDB.12.0;数据 源= | DataDirectory | \ myAccess2007file.accdb;持久安全性 信息=假;

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccess2007file.accdb;Persist Security Info=False;

这篇关于MS Access数据库的Vb.net连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！