Form crashes on 1 PC only (1 Viewer)

arch1

New member
Local time
Today, 09:05
Joined
Dec 20, 2013
Messages
1
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

I know a few things...
Local time
Today, 04:05
Joined
Oct 23, 2001
Messages
2,633
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

AWF VIP
Local time
Today, 09:05
Joined
May 23, 2011
Messages
4,717
Has the db been split, with a copy of the front end on each users machine.
 

missinglinq

AWF VIP
Local time
Today, 05:05
Joined
Jun 20, 2003
Messages
6,423
...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)>
 

Users who are viewing this thread

Top Bottom