Linked tables and subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access mdb for both back and from ends. When working on the front
end file I usually copy all the table across and work on the local drive.
After modifications I then relink the table and and make an mde file for the
users. This system works fine majority of the time. Some times when and
relink the tables my subforms and then don't run properly, just white
background and no fields showing. I never understand this because on the
local copy on the tables everything runs just fine. If anyone outthere has a
solusion, I would very much appreciate it. thanks
 
Only "sometimes"? That sounds like other times it does work properly. Do
you notice anything different between the times it works and the times it
doesn't?

Perhaps the way you are re-linking is different from time to time?
 
Thanks for your reply Jeff.

It happend a while ago and I can't quit remember what course then or how I
managed to fix it. I panicked a bit this morning because I made the mistake
of replacing the live file with my local copy without relinking the tables
and in my atempt to correct the quickly, I missed one of the tables off the
list. I didn't think that is what has coused all my subforms to not to run,
but once I corrected that everything seems to be back to normal. Thanks for
your reponse.
 
Back
Top