I have an Access 2003 database consisting of a 'front end' residing on four different desktops which are linked to tables residing on a server.
All clients are running XP Professional SP3.
On the rare occasions I need to make changes I do so, and then copy the client.mdb file to the other three desktops. Yesterday, I added some new functions (using a query to output data to a file) to a module and copied the file over to the other desktops. The compiler reported no problems with my additions.
This morning we have two machines that present no problems whatsoever; one of which is mine.
The other two have multiple problems.
The most obvious (and easily described) occurs on the form which auto opens when the database is opened. There is an unbound text box which displays the current date using the date() function as its default value.
On the machines with the problems, #Name? is displayed instead.
I have ensured we are all opening the same copy!
The problem also occurs if one of the problem clients opens another client's copy across the network which works fine on that machine.
And now I discover the problem also occurs on older copies of the client mdb going back (so far) to last November.
The problem machines are fully patched and I've run Malwarebytes software on both with no issues reported.
Since it would appear to be machine specific I am at a total loss as to what the problem is and why it has suddenly occured!
Any help would be greatly appreciated.