Click here to Skip to main content
15,671,149 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I use this Connection Code to insert, update & delete the content
Dim constr As String = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Server.MapPath("../databasename.mdb;")& "Jet OLEDB:Database Password=mypassword;"

Which Work Fine,

Now when I Load the Data into Some Page from Database, the Webpage Display Error & Redirect to Error Page.

For Load Data I use Following code :

<asp:AccessDataSource ID="ADSource" runat="server" DataFile="~/databasename.mdb" SelectCommand="SELECT * FROM [Table]"></asp:AccessDataSource>

1) Why, Its because I didn't add password into above code? If Yes, How to Add Password into Above Code?

2) How to Set above Connection Code into Web.config & Use it into Webpage?
Updated 11-Sep-12 0:01am

1 solution

The AccessDataSource will not connect to an Access database that is password-protected; to retrieve data from a password-protected Access database, use the SqlDataSource control.[^]
Share this answer
s1a2b3 11-Sep-12 6:14am    
that means i have to convert my database in MS SQL?
Can you Give Me Sample Code for SqlDataSource with Above Parameters?
Kuthuparakkal 11-Sep-12 6:25am

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900