Saturday, August 27, 2016

Rollover  Beethoven - Access Web Database Users Beware

Ok I know that there are less people in the world that use Access Web databases than there are people that know that Beethoven's ninth was the feature music in the cult R rated film, Clockwork Orange.

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 , 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. :(

No comments: