Access Error 3027 when using VBA to append table to a linked table

[carcement]

Sure, here's the link in my dropbox:


https://www.dropbox.com/s/1xd3sofufp...bmission.accdb

The form allows me to add the images to the submit table, I just double click in the attachment box and select a random picture from my hard drive.

[rpeare]

Umm it works. Did you try deleting the data from IMGDEST before re-running your code?

[carcement]

Hm, that's strange as it doesn't work for me. I do clear out IMGDEST before running the code.

[rpeare]

The version of the database you just uploaded to me there is data in the IMGDEST table. There is no deletion of data in the code on the SUBMIT button either. So I would suggest deleting the data by hand (for now) re-running your code (as I did) and you'll find an image in door 3.

[carcement]

Hm, I think I've found the problem - the code apparently only works if the route # is unique.

[rpeare]

Correct, there is no 'unique identifier' that is being carried from one table to the next to help identify it as such. If you want that functionality you can do one of two things:

1. Carry the PK from your SUBMIT table to your IMGDEST, something like SUBMITID
2. Remove the check in the code that is checking to see if there is a record already existing in the IMGDEST table. Just a warning if you do this though you will basically be copying every record from your SUBMIT table to your IMGDEST table every time you run the code which will make it slower. The code currently only adds 'new' records (new routes which you'd have to change to new SubmitID's).