DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    Updating Access db from ASP.NET2 server control

    I'm new to web development and am trying to update an Access 2000 database (mdb file) from ASP.NET2 code using a SqlDataSource server control. I can view and filter the data in the bound GridView server control and can insert records using the DetailsView server control. However, I cannot update existing ones with DetailsView. No exception is thrown in the DetailsView1_ItemUpdated handler and no error message appears. - The AffectedRows property is 0.

    I understand the dot net framework uses a fallback data provider for Access databases, namely OLE DB (4.0), which I state in the web.config file. I am now wondering if there's a limitation using this data provider. I have disabled anonymous access and enabled Windows Integrated Windows authentication in web.config. So I assumed the impersonated identity would give the ASP.NET2 process sufficient permissions to update a database resource. - I log in to Windows as an administrator account. The mdb has both read and write attributes set.
    My web server is IIS 5.1 (I'm working offline) and the op system is XP Pro. I've created a virtual folder for the web app in Internet Information Services' wwwroot etc.

    I would appreciate any help.


  2. #2
    Join Date
    Dec 2003
    Jet OLEDB is not the fallback provider for an Access database. It is the only provider that you should be using (with the .NET OLEDB namespaces).

    The SQL namespaces were designed for SQL Server.
    Microsoft MVP (Visual Basic)

Similar Threads

  1. find version & service packs
    By rperez in forum Database
    Replies: 5
    Last Post: 01-02-2009, 04:14 PM
  2. Replies: 1
    Last Post: 02-05-2002, 12:53 AM
  3. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 12:22 PM
  4. Access to SQL server
    By Nate in forum Database
    Replies: 29
    Last Post: 05-09-2001, 10:04 AM
  5. Re: Updating Access DB w/ DCOM
    By D. Patrick Hoerter in forum Enterprise
    Replies: 0
    Last Post: 09-23-2000, 02:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.