If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Triggers and Access forms
Hi,
I have a major problem with Access forms, I developed a form based on SQL Server table (.adp file). I'll describe the tables: Table Employee (ID, Name etc.) Table Products (ID, Name etc.) Table Commisions (EmpID, ProductID, Commision) Table Employee has an after insert trigger that adds commision records for each product in the Products table. The same trigger fiers after addition to the Products table. So the table Commisions is managed using Triggers only. The problem is like this: I created a form for the Employee table, but whenever I want to add an employee i get this messege: "Key column information insufficient or incorrect. Too many rows were affected by update" The data is added to the table but i cant see it in the form. only if i open it afterwards with this record. How can i prevent this messege and make the form act normally. like theres no trigger ? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Triggers and Access | Maury Markowitz | General Discussion | 0 | December 3rd, 2004 03:09 PM |
Access 2003 adp/proxy security - A substitute for SYSTEM_USER() | Kimberley Yochum | General Discussion | 0 | November 23rd, 2004 10:21 PM |
Triggers in Access | Rajesh S | Running & Setting Up Queries | 1 | November 1st, 2004 09:44 AM |
triggers in MS Access | Prashanth | Running & Setting Up Queries | 1 | October 26th, 2004 04:51 PM |
TRIGGER a VIEW with SQL for a LINKED SERVER (ACCESS DB) | youssef | General Discussion | 10 | July 13th, 2004 12:00 AM |