Forms will not open on certain computers

[sphere_monk]

Hi everyone,

We've been experiencing some strange behavior with some of our forms for the last few months and I am at a loss to explain or resolve it.

Certain forms work fine on the development machine, but as soon as the front-end of the database is copied onto other computers, the forms will not open. Trying to open them hangs Access. The work-around has been to open the form in design view (on the computers with the problem) and hit 'save'. Then the forms will work fine.

The forms affected are forms that do not have an underlying record source. I have tried attaching tables to these forms (although I'm not actually using any records from them) but that did not help, and it was at best another workaround.

We are running Access 2007. The development computer is running Windows Vista, and the user's computers are all Windows XP. We are all on the same Access update.

Has anyone experienced this? Any ideas would be appreciated. I'm completely stumped.

Thanks

Dan

 

[boblarson]

Just a shot in the dark, but have you set up the database's location as a Trusted Location on each computer?

 

[sphere_monk]

Hi Bob, thanks for the response.

Yes, the user's computers have all been set up with trusted locations of all the front-end and back-end databases. Each user accesses multiple front-end and back-end databases. This form problem spans all the databases. The databases are quite large and have 100 - 200 forms in each. This problem only affects 5 or 6 forms in total.

I have other forms in the databases that have no underlying table, and those work fine. And I recently had a form that worked fine until I entered the form in design mode on the development computer, updated a few fonts, font colors and the tiled picture of the form. Now it behaves like the other forms that have problems. (The fonts and tiled picture are used on other forms that work just fine. The picture is an embedded-type picture).