Errors Galore 2427, 2447, 2465, 3075, 3079, 3420

[JohnHarkins]

I'm installing an application for a client who has about 20 simultaneous users. With rare exception, the application works just fine with one user and fails with one or more of the above error codes.

2427 You entered an expression that has no value
2447 Invalid use of dot operator
2465 Run time error <application name> can't find the field '|' referred to in your expression
3075 Problem with <field name> (Now there's some helpful information.
3079 Reserved Error (THIS IS ANOTHER BEAUTY... can't figure it out at all... it comes and goes.)
3420 Object invalid or no longer set when selecting action (THIS IS ABSOLUTELY THE WORST ONE, as it locks up the system and users go crazy... I would, too.)

When I call up Help, I am not getting any particularly useful information about these codes. Is there some place you could recommend to understand not only what they mean, but how to isolate the problem code. I'm really about at my wit's end.

Any reasonable suggestion welcomed.

Regards,

John Harkins

 

[KenReay]

Hi

Ok so theer are 20 users and one is working OK, is that the situation?

Presumably you have a frontend/ backend (ie two mdb files, one with data, one with User Interface)?

Presuambly the FE is located on the C: drive of each users PC, and BE on a network share ?

First thing I would try was on ONE none working PC, copy the 'good' (ie working) FE to that PC, does it work?, if yes repeat for the rest, if no, check the references on the none working PC

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK