I use MSAccess as my front end. We may move to VB.Net but that is down the road.
When using a table in Access a User can read and write (given the proper permissions).
However, using a view the user can only read the data.
I would like to use a where clause which is available in Views to filter/narrow the amount of info. Is there way to to but read and write with a view?
Is ther another way to accomplish this.