Update Excel Database

Discussion in 'ASP.NET 2.0' started by Aristotle, Aug 25, 2006.

  1. What error are you getting when trying to insert?

    Aristotle

    DiscountASP.NET
    www.DiscountASP.NET
     
  2. I have my asp.net membership database attached to the SQL database and all is fine with forms authentication and all that. It took a while but I got it going. Now...

    I have an Access database that holds data for the web application that resides on the server also. The bound data fields load into my application just as they should but I cannot update fields or add new rows.

    Here's a sample ofthe code I'm using...

    Dim strSQL as string
    strSQL = "INSERT INTO [table] name data"
    MyIODatabase.insertcommand = strSQL ' VWD data control
    MyIODatabase.update()

    This worked fine before. It doesn't work from the site. Do I have to buy a second SQL database to do this?

    Thanks.

    Lawrence
     

Share This Page