I have a dB in SQL Server with Access 2000 front end. All is well, until I recently added some more users in SQL Server. Now those new users get this error when the application starts, specifically at a line that reads "Set cnnConnection = CurrentProject.Connection". Now this code works fine for everyone else, and it is not all new users that get the problem. But if they have the problem, no amount of removing or recreating the SQL Server user makes any difference.
One difference is that the users affected are in a new AD child domain from previous users (although not all users in the new child domain exhibit teh fault).
Everyone runs the application via a single Terminal Server machine, so it cannot be a problem of different s/w as they are all running the same thing.
Anyone have any ideas?