Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tamas
  • Order by date
  1. tamas

    Delete cascade trigger

    Hi, I have a self-referencing table, something like Emlplyee-Manager. I want to implement the cascading delete in this table. So when I delete a manager than all the employees should be deleted at ANY level below the manager. My problem is that the trigger fires only one time (for the...
  2. tamas

    Boolean default value prevent inserting

    Hi, I want to upsize my Access backend to SQL Server 7. I have a form having as recordsource SQL statement based on 2 tables in a 1:n Left Join relation. When I try to insert a new record in the form I receive the error 3101: The Jet engine can't find in "Parent" tabel adequate...
  3. tamas

    Writing conflict

    Thanks for your intersert but the problem is solved now. The problem was that I had records with fields of type bit in SQL Server which was not initialised. I mean Null insted of 0 or 1. When the bit type fields got a value the problem disappear. Thanks anyway
  4. tamas

    Writing conflict

    Hi, I want to modify a field in a record. When I try to modify the record from Access environment, dispite the fact that I'm the only user I receive always the writing conflict messagebox with 3 buttons:"save record", "copy to clipboard" and "reject" (the caption...

Part and Inventory Search

Back
Top