DataView with Microsoft Access

From: Terry Liston (terry.liston_at_amec.com)
Date: 06/28/04

  • Next message: Edward Lee: "Re: sharing spreadsheets" 
    Date: 28 Jun 2004 13:37:03 -0700

    I can insert a dataview and configure SQL Server with no problems, but
    have been unable to figure out how to connect to a table in an Access
    Database. The access Database is on the server, and the directory has
    permissions set to allow IIS to read/write/delete/edit

    The connection string I am using is:

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\Test.mdb;Persist
    Security Info=False

    That string is just a guess I constructed. The error returned is:

    "An error occured while retreiving the list of databases from
    c:\temp\test.mdb....

    Any Hints?

  • Next message: Edward Lee: "Re: sharing spreadsheets"