Click here to Skip to main content
15,302,185 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL table not allowing insert.

getting error- Run-time-error: no insertion allowed in this table.


Please help!
Posted
Updated 20-Mar-15 21:52pm
v2
Comments
King Fisher 21-Mar-15 3:46am
   
What error?what is your table structure? what are you trying to insert? show something to us. we don't know what do you have.So,please update you question with some Information. ;)
jawad59 21-Mar-15 4:04am
   
everything was working fine. all of sudden, a table stopped taking entry from the software. while other tables works fine with insert to same db

1 solution

Check your user (the one you log in to SQL with when you connect): it's possible that you don't have any insert or update rights on the DB.
   
Comments
jawad59 21-Mar-15 4:03am
   
Other tables are allowing insert. only one table is not allowing insert.
[no name] 21-Mar-15 4:06am
   
Post ur code here..
jawad59 21-Mar-15 4:10am
   
everything was working fine. all of sudden, a table stopped taking entry from the software. while other tables works fine with insert to same db.

I think it can be related to permissions.. I even gave all permissions then.. still same error

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900