Hi all,

The question is in the subject, I have some problems accessing data from a Microsoft Access Database.
So, is it possible ? and if yes, anyone could tell me what is wrong in my settings :

Active Datasource = Generic ADO.NET datasource
ADO.NET Data Provider  = OleDb Data Provider
Connection String = provider=Microsoft.Jet.OLEDB.4.0;Datasource=D:\Database\Database.mdb;
Query = SELECT * FROM Table

Many thanks for your help
Jocelyn

Hi Andrew,

I receive this error message : There was an error executing the data source: An error occurred while executing the data source (Code: -2147467259): Unspecified error

Unfortunatly, I don't know where is the problem... The Access database is located on the same server as DNN but not in the site folder.
I assume that this folder must be accessed by DNN and then I've putted correct access rights (NETWORK SERVICE and ASPNET accounts have read/write access to the database folder.)

Hope it can help
Jocelyn

Jocelyn:

An alternative you may want to explore, and this depend on the level of access you have to your SQL Server, is to create a linked server from SQL Server to the MS-Access database.  I did this once but I only needed read-only access from the Access database, never tried writing to it this way.  I don't have a reference to the article with the details on how to do this right now but if you look you will find it.  I also used Views in SQL Server pointing to the tables I needed in the Access DB.  In this way all your DB transactions are via SQL Server, no need for direct access from your code to the Access DB.  You don't need to modify the Web.config either.

Hope this helps.

Carlos