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:
Hi
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,.

PLEASE HELP!
Posted
Updated 23-Mar-15 21:14pm
v2
Comments
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