Results 1 to 3 of 3

UPDATE 3073 error trying to update a table field

  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,115

    UPDATE 3073 error trying to update a table field

    Could this error be caused because the table of interest is located in an mde file in the root? (I.e., c:\)
    Click image for larger version. 

Name:	000.jpg 
Views:	6 
Size:	83.3 KB 
ID:	35781

  2. #2
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    6,131
    possibly - if the mde is in a folder you do not have write access to - I certainly know of companies who disable users from being able to put files in the c:\ root - it is not a particularly good place to use.

    with regards the message, that is not one I've seen before and wonder if it is being generated by error handling code

    not clear to me why you have vba code as a backdrop to your error and message (and the debug button looks active) but you are talking about a mde

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,115
    HA! I thought I was being clever by sandwiching the VBA UPDATE statement between the two Access messages in taking the screenshot, one when the error was raised and the other when the error Help was requested.

    I agree with you regarding the placement of the file directly in the root and I don't remember if I've ever done that in the past......... I had a special reason for doing so but will dream up an alternative. Like you, I've never seen the error before and while it was easy to test removal of the error with a simple copy elsewhere and re-link I was curious as to whether anyone else had seen the error.

    At this point, I don't think it's worth the time and effort to pursue Win 10 permission policies to see if the file can remain in the root without errors, but clearly that was the problem.

    Thanks,
    Bill

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 09-16-2018, 12:18 PM
  2. Replies: 2
    Last Post: 02-23-2017, 09:46 AM
  3. Replies: 19
    Last Post: 08-08-2013, 12:17 PM
  4. Replies: 1
    Last Post: 05-17-2013, 11:53 AM
  5. Update field in table after update on a subform
    By jpkeller55 in forum Queries
    Replies: 3
    Last Post: 09-30-2010, 07:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums