I have a database (A2003) being used by an off-site client. In order to reasonably assure that all data changes are recorded in a programmed audit trail, I have shut the users out of the db window: main menu form opens on startup and can't be unloaded unless db is shut down (form is modal and minimize is disabled). I am not using Access workgroup security because I don't want to administer it remotely.
So: naturally enough, they want to be able to query their data. (They have prewritten queries that run off of buttons, but of course they have new questions all the time.) I'm wondering, is there a way that I can give them a QBE interface without letting them into the actual db window?
So: naturally enough, they want to be able to query their data. (They have prewritten queries that run off of buttons, but of course they have new questions all the time.) I'm wondering, is there a way that I can give them a QBE interface without letting them into the actual db window?