I know nothing about Access and I'm not even sure what you mean by switchboard forms. So strictly theoretically speaking the problem with changes like this is often the users not the software. The users who had their routine, their habits, their field of knowledge removed and substituted with something else. They will resent this unless they wanted it too or they get something out of it

One way to ease them into the new world is to give them some new capabilities or some new comfort functions that can't be done easily with the old software, otherwise they will bathe in nostalgia. For example such a comfort function could be that they can get an email whenever some specific part of the database changes or combining the database with a wiki or reports with statistics included