PDA

View Full Version : ASP.NET - ACCES DATABASE


annemie
01-11-2004, 02:23 AM
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 ?

Eric
01-11-2004, 05:14 AM
Are you receiving an error message?

annemie
01-11-2004, 09:15 AM
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()

bruce
01-12-2004, 12:27 PM
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.

[b]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">

msword
01-21-2004, 01:29 AM
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.