I've finished building an entire web app that our remote sales team can log into and add the opportunities they are working on so that we no longer need to circulate spreadsheets to gather this information. After some trials and tribulations, I was able to implement security by using a macro that kicked off when a view was opened so the user can only see their opportunities. (I have a previous post on this if you're curious).
Today, however, one of the salespeople exposed a major issue when they pressed the download arrow in the datasheet view as well as the query I had built for them. When they download, they get all records from the database!! Help, how do I prevent this from happening? It doesn't appear that you can remove the download arrow because it doesn't exist in the client view where I edit things. I can't remove the action bar because they wouldn't be able to add new records then. Since the download arrow doesn't exist in the client view, I can't hook a macro into it to prevent the user from downloading all records.
This is major bug if I can't get this remedied. I'll probably have to shut down this entire database project if I can't figure out how to prevent people from downloading all records.
So far a google search hasn't yielded me any results other than Microsoft saying this is a "feature".
Has anyone found a workaround for this?