SQL Table not allowing insertion

Question

0.00/5 (No votes)

See more:

VB6

SQL

SQL-Server

SQL table not allowing insert.

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

Please help!

Posted 20-Mar-15 21:39pm

jawad59

Updated 20-Mar-15 21:52pm

v2

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2015-03-20T21:51:00

Solution 1

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.

Posted 20-Mar-15 21:51pm

OriginalGriff

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