Form crashes on 1 PC only

[arch1]

hi there,
we use access 2007 and work and have a database that is saved on 1 PC and accessed by several others. On one of the PCs one of the forms (and tables) hangs and the whole database freezes. This doesn't happen on any of the other PCs and they are all running the same software.
I've checked Trusted Locations, and compacted and repaired the database but still no solution.
Can anyone help?

thanks

 

[David R]

Can you open the database on that PC in developer mode, add a breakpoint, and step through your code? Do you know at what point it freezes (switchboard load, first saved record, etc?

I've had that happen a few times when some bad reference or whatever hits my code...

 

[bob fitz]

Has the db been split, with a copy of the front end on each users machine.

 

[missinglinq]

...Has the db been split, with a copy of the front end on each users machine...

That was going to be my question, too, especially given the statement

"...have a database that is saved on 1 PC and accessed by several others..."

which sounds as if they're accessing a single copy of the database. Not having a properly split database, when working in a multi-user environment, leads to a whole plethora of problems, including crashing forms, often only experienced by one or two users!

Linq ;0)>