Updating forms and tables remotely causes the form not to work when I get into work

[atrium]

I do a lot of development after hours from home. I log into the network (terminal server) via login and password.
I can update forms, reports, queries, tables etc and have no problem running them from home.
When I get into work some of the forms will not work. The event button on one form can be clicked and it appears that its about to work but nothing happens. If I then open the not working form in Design View (At work) and make the slightest change and then save the form on exit it works.

Can someone tell me how I can overcome this annoying problem.

I have had a look at the trust centre but can't figure out how to set up my location at home. No static IP at home.

Any information much appreciated

Atrium

 

[arnelgp]

do you have same version of access at home at work?

 

[CJ_London]

if you are using terminal server, presumably the front end you work on is located there as well (it should be)?

 

[missinglinq]

...I have had a look at the trust centre but can't figure out how to set up my location at home...

...The event button on one form can be clicked...but nothing happens. If I then open the not working form in Design View (At work) and make the slightest change and then save the form on exit it works...

I suspect that more to the point is how the Trust is set for the machines at work, rather than updating the Forms at home.

A new quirk in Access (like it needed another quirk!) involves code/macros running, when switching from Design View to Form View, but not running if the Form is then closed and re-opened directly in Form View! It turns out that the Redmond developers assumed that if your are working from 'inside' Access, as it were, you were 'trust-worthy,' so code will run, even if the Folder holding the file hasn't been declared as a 'Trusted' site! But when opened directly, that Folder needs to have that 'Trusted' attribute in place. From your description this sounds like the behavior you're seeing.

Linq ;0)>

 

[atrium]

Thanks guys, logging in to the terminal server from home.
Sounds like missimglinq might be on the money.

How can I fix that?

Thanks for your help

 

[atrium]

AH just had a thought.
I have two versions of the project. A development version and a LIVE version. I make all changes in the development version, test and then copy the new version into the LIVE site. I must check if the both the Live and Development directories are trusted folders on the work machine.

 

[atrium]

Yes both folders are trusted folders in the trust centre

 

[atrium]

In answer to CJ_London

YES When I login remotely I log into my normal account on the server