Dan Waters
dwaters at usinternet.com
Wed Feb 3 06:11:18 CST 2010
Well - no joy. Good idea though. Thanks, Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Saturday, January 30, 2010 12:06 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Ask Again? - Updateable Query - Access vs. SQL Server Dan, Weird I know, but from time to time this has happened to me. I have found that deleting the query and creating a new query (not cut n paste, but a brand new query) has cured it. Some flag incorrectly set in the "behind the scenes" sql code perhaps) Shrug! Try it and see if it works. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: 29 January 2010 22:18 To: 'Access Developers discussion and problem solving' Subject: [AccessD] Ask Again? - Updateable Query - Access vs. SQL Server I have an Access file which contains a LEFT JOIN query between two tables. If the query uses table links to an Access BE, the query is updateable - which it should be. But if the query uses ODBC table links to a SS Express database on my PC, then the query is not updateable. To compound the mystery, the same Access query using ODBC table links to a standard SQL Server database with the same tables IS updateable! Does anyone know what's up with this or how it can be fixed? Thanks! Dan -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com