Click here to Skip to main content
15,306,281 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
We have two different databases on sql server 2005, with same database structure and using the software developed in VB6. There is a table name 'acctran' in both databases. When insert command is given from program, it shows Runtime error- no insertion allowed in this table

When I create duplicate table and give different name to original table and 'acctran' name to duplicated table with all data copied into it, it works for 1 day, next day same thing occurs again.

Also all table permissions are given,.

Updated 23-Mar-15 21:14pm
Varun Sareen 24-Mar-15 3:24am
Don't repaet questions. the same you have posted two days ago.
jawad59 24-Mar-15 4:29am
but, didn't got the solution yet

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

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