VS05 is the simplest, most beautiful, and most convenient method for connecting to the MS Access Database

I searched many methods on the network and found that the method was the best.

Step 1: copy a MS Access database to the App_Data directory

Step 2: configure the web. config Node

Code
<ConnectionStrings>
<Add name = "dbConnection"
ConnectionString = "Provider = Microsoft. Jet. OLEDB.4.0; Data Source = | DataDirectory | cms. mdb; Persist Security Info = True"
ProviderName = "System. Data. OleDb"/>
</ConnectionStrings>

 

Step 2: Call

ConfigurationManager. ConnectionStrings [_ config]. ConnectionString