runtime error 2105 (1 Viewer)

Okay Bob now it looks like I can add new records. However, with the first statement SELECT Clients.*, [Attachment].FileName FROM Clients; I have 69 records and now I only have 53.

gizmogeek said:

Okay Bob now it looks like I can add new records. However, with the first statement SELECT Clients.*, [Attachment].FileName FROM Clients; I have 69 records and now I only have 53.

Click to expand...

Yep, and that is because you have more than one attachment for some records. The * will include the attachment field properly so that you can add/delete, etc. from that field. The only time you want to use Attachment.FileName is when you have a query for a Report or some other query which you do not need to have it be updateable.

Thanks so much Bob!! Now I can get back to my regular project.