#NAME? on 3 PC's

  • Thread starter Thread starter Scott Rosen
  • Start date Start date
S

Scott Rosen

I have a front end and back end database.

Access 2002
All SP and updates applied
All machines identical

Three machines get #NAME? in all the fields in the form
when refresh. The user clicks on a field that contains a
list box from another table(Me.Requery is where debug
stops) We know it is not a network problem.

It doesn't happen every time either, Sometimes once an
hour and sometimes every other time refresh is pressed.

FYI the DB's are in Access 2000 format (if that matters)

Thanks for the help,

Scott

P.S. I will paypal anyone a 100.00 for finding the
solution to the problem.
 
Are you absolutely sure that all of the machines have the exact same
front-end (i.e. fresh copy of the FE?)
 
Yes. I can copy the FE to the machine and it may work
for a little while and then it starts again.

I am really lost
 
I would try to wipe all the FE's on the three computers,
and then re-copy them from the server to a Floppy or CD
and put them onto the 3 computers that way, your NICs in
the three computers may be corrupting the data when passed
over the network.Unlikely, but possable.
 
I'm experiencing the same problem on a Access 2000 db
running on WinXP - works fine under Win98 OS. Bombs
right on the Me.requery statement. any fixes found yet?
I'd hate to have to re-install Win98.
 
Back
Top