I am having a serious problem with my database application using MSAccess. After sometime SQLException General error and this error doesnt goes ever after restarting the program once it comes.Is there a solution to this or I have to swithc to another database.
Amit Barot
Greenhorn
Joined: May 29, 2001
Posts: 13
posted
0
According to your description the problem seems to be blank fields in the database that is the primary key might be blank so try to fill in that key in all the records or delete that row and then try if this fixes your problem then its well and good try solving my problem!
rani bedi
Ranch Hand
Joined: Feb 06, 2001
Posts: 358
posted
0
Can you elaborate your problem?
Cheers,<br />Rani<br />SCJP, SCWCD, SCBCD
Amit Barot
Greenhorn
Joined: May 29, 2001
Posts: 13
posted
0
hi again i just found out the GENERAL ERROR usually comes when u insert duplicate entries in the primary field in the database ok hope this will solve your problem bye and let me know what if u make it thru bye .
sudharma malkas
Greenhorn
Joined: Mar 03, 2001
Posts: 9
posted
0
I found that problem comes once any field is left empty and the doesnt go away even if I restart the program. the exception message is java.sql.SQLException : General Error The problem goes only when I restart the computer. I am thinking of putting a blank field check but it is still a serious problem which should have some way out.
[This message has been edited by sudharma malkas (edited June 01, 2001).]
0
