By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,873 Members | 1,040 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,873 IT Pros & Developers. It's quick & easy.

Subform datasheet built using SELECT DISTINCT query does not allow record updating

lwwhite
P: 16
I've got a a datasheet subform that gets its data from a SELECT DISTINCT query. The data is not editable. When I remove the DISTINCT qualifier from the query, the data is editable, but of course I get a much longer record set. I understand why Access doesn't want to let the data be editable in this situation, but I'm hoping there is a way to circumvent this restriction. Thanks for any suggestions. (Access 2003)
Jan 31 '07 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,668
I've got a a datasheet subform that gets its data from a SELECT DISTINCT query. The data is not editable. When I remove the DISTINCT qualifier from the query, the data is editable, but of course I get a much longer record set. I understand why Access doesn't want to let the data be editable in this situation, but I'm hoping there is a way to circumvent this restriction. Thanks for any suggestions. (Access 2003)
Using DISTINCT or UniqueValues = True will by design and necessity make the resulting Recordset Non-Editable/Updateable. There is no way around this restriction that I know of. If you set the UniqueRecords property to True, however, the Recordset will be updateable but this may not produce the desired result and I don't know the details of the Query itself. Here is a definition of the UniqueRecords property:
You can use the UniqueRecords property (DISTINCTROW) to specify whether to return only unique records based on "all" fields in the underlying data source, not just those fields present in the query itself.
Jan 31 '07 #2

NeoPa
Expert Mod 15k+
P: 31,566
The UniqueRecords property is equivalent to the SQL predicate DISTINCTROW.
Feb 1 '07 #3

ADezii
Expert 5K+
P: 8,668
The UniqueRecords property is equivalent to the SQL predicate DISTINCTROW.
Thanks NeoPa - I edited my response.
Feb 1 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.