[AccessD] Ask Again? - Updateable Query - Access vs. SQL Server

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




More information about the AccessD mailing list