Multiuser access 97 runtime error
I have a multiuser access 97 database that is stored on a server and accessed through the network by different users. The database is not split into front end and back end.
I can successfully execute several queries on my machine under both my profile and the administrator profile. However on the other machines that access the database the exact same queries are giving a run-time error "2427" saying that I have entered an expression that has no value. This happens under the user's profile, my profile and even the administrator profile.
All references are the same and I've even tried redoing one of the machines so that it's the same as mine and I'm still getting the same problem.
I've tried reinstalling Access and ensured that all references and the MDAC version is the same on all the machines but it hasn't made a difference.
Any help would be greatly appreciated.