ASP.NET - ACCES DATABASE

Discussion in 'ASP.NET / ASP.NET Core' started by annemie, Jan 11, 2004.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I cannot write, delete, insert with a sql statement in an access database.
    The program is written in asp.net with vb.net (visual studio .net 2003)
    The program works in another computer but not in my computer.
    I think the problem is in the access database (office 2000)

    What is the problem ?
     
  2. Takeshi Eto

    Takeshi Eto DiscountASP.NET Staff

    Are you receiving an error message?
     
  3. by delete : cannot delete from the tabel - message - by the instruction : rs.ExecuteNonQuery()

    by write : no message - the table does not change

    by insert : the insert must be on a query who can be tide up - message - by the instruction : rs.ExecuteNonQuery()
     
  4. Bruce

    Bruce DiscountASP.NET Staff

    Hmmm... does your asp.net page has any error trapping?

    It is not really possible (at least I have not heard of this) that the query executes successfully but the DB is not being updated.

    quote:Originally posted by annemie

    by delete : cannot delete from the tabel - message - by the instruction : rs.ExecuteNonQuery()

    by write : no message - the table does not change

    by insert : the insert must be on a query who can be tide up - message - by the instruction : rs.ExecuteNonQuery()
    </blockquote id="quote"></font id="quote">
     
  5. did you make sure the rights are set correctly? if you cant insert,delete,update ect... then it sounds like a rights issue. That's what I gather based on your NFO provided.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page