Saturday, August 27, 2016
Rollover Beethoven - Access Web Database Users Beware
That ridiculous analogy aside, if you have an Access web database, then beware when Microsoft asks you politely if you mind changing servers. If you agree, you may find your odbc 11 linked tables sending out weird readonly messages. What has happened is you will still be connected to your old server and that server will be readonly. Meanwhile in the cloud, your new server is working ok and Office 365 cloud data is being stored there. This new data is not visible in your old links. That's the symptoms.
All I can suggest that you do is open up your Access Web Project file in design mode and find those Connection buried under the File menu. Now reenter your new connections into your odbc 32 links and you will be on the way. I hope.
Meanwhile I feel like I have been done over by Malcolm McDowell, the star of Clockwork trying to work this out. I thought adding a project to my Web database system tonight was only going to take a minute, little did I know. :(