Data is unuptadeable because it contains top clause
Data is unuptadeable because it contains top clause
True. So why do you use it?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Your profile shows:Cant edit data
Data is unuptadeable because it contains top clause
So I'm guessing that you're using Access and not SQL Server.Windows Version: Windows 10
Access Version: Access 2013 64bit
2 posts
I just tried in Access 2019 and it was updateable just fine. And by the way of course another way to restrict data is with the WHERE clause to perhaps just show records within the past week. And there is the ORDER BY clause to perhaps just show the most recent records first...
Ooops, I was thinking Distinct, don't know why, just mixed up.
Post your query SQL statement.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.