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 ?
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.
vBulletin® ©Jelsoft Enterprises Ltd.