Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    182

    Unanswered: Problems writing to multiple tables

    I am trying to add a new record which actually adds details to 2 tables but I can only get the data writen to one table and I am getting a Write Conflict error.

  2. #2
    Join Date
    Jun 2002
    Posts
    63
    It may be worth rebooting your machine, I have had similar problems, where windows leaves the open flag on files then causes problems when you try to open them again.

  3. #3
    Join Date
    Apr 2004
    Posts
    182
    How do you add data to two tables at the same time ?

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by livvie
    How do you add data to two tables at the same time ?
    Hi livvie,

    If you could post a sample of your database you might get help sooner. It depends on how you have your tables setup to begin with. But without seeing it there will be much guessing going on. Zip it, Attach It and see what comes your way. Sounds like a relationship problem so far though.

    Bud

  5. #5
    Join Date
    Apr 2004
    Posts
    182
    Hi Bud
    Attached is my DB. I can get the records added to one table and they appear to be added to the second (ie it does pass thru the code) but the records do not appear. Have a look and let me know what questions I need to answer. The problem is on the frmDrawings Complete form.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •