Microsoft Access: Constantly have to refresh table link if a table has an attachment field in it

My database is divided into a front-end and back-end. I regularly make updates to the front-end and then copy the front-end from my computer to my client's computer. Today, I added an attachment field (i.e. data type = attachment) to one of the tables in the back-end. It works fine on my computer. But when I copy the front-end to the client's computer, I get this error whenever I attempt to open a form that references the table with the attachment field in it:

The Microsoft Office Access database engine cannot find the input table or query ''. Make sure that it exists and that its name is spelled correctly.

When I go into the Linked Table Manager, it says it is pointed to the right back-end file. But if I check the box beside that table and click OK, the above error goes away and I can use the database without any further problems.

Or, if I execute this command:

db.TableDefs("tblCustomers").RefreshLink

it also fixes the problem. But I have to do that every time I copy a new front-end to the client computer.

If I delete the attachment field from the table, the above problem goes away and I can copy front-ends without any errors or the need to refresh links. But as soon as I re-add an attachment field to the table, the problem comes up again.

Any suggestions?
jrmcanada2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

John TsioumprisSoftware & Systems EngineerCommented:
Well it might be a longshot but i found an also similar case and the culprit was not the Attachment field but rather a Memo Field because it the Property "Append Only" to Yes that caused data to get pushed to a system table...so the info was retained on the system table and because it was the old one...there was an issue...until the Relinking was used to refresh the info.
Here is the discussion
jrmcanada2Author Commented:
This gave me hope because the table does have 5 memo fields. Alas, they all have the Append Only property set to No.
Jim Dettman (EE MVE)President / OwnerCommented:
Both attachment fields and multi-value fields are achieved behind the scenes using system tables as John mentioned (and FWIW, I would not use either, but do it myself).

 That being the case and you know what the solution is, I would side step the problem rather than trying to understand it; simply refresh all your table links when the app starts up.

  You can set it up so that it only does it once and that way it really won't impact things too much.    But a refresh is really quick and you might just want to leave it so that it runs every time.

Jim.
Daniel PineaultPresident / Owner CARDA Consultants Inc.Commented:
I'd delete the attachment(s) field(s), and store them on the server.  There are several reason to do so, as you are seeing firsthand.  If you want to learn more, refer to Adding Attachments to an Access Database.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.