Access: Can forms and queries be save out of the db?

[revnice]

I don't want my users to open the db but I do need them to be able to run a canned query or open a form.

Can forms and queries be run from an icon on a remote user's desktop?



Thanks - rev

[TheShabz]

Not that I know of. An option you do have however is splitting the database. you can have the backend which only you have access to on a network drive and the front end on each user's desktop. The tables will be located on the backend and queries/forms will be located on the frontend. this will keep your IDtenTs from screwing things up =]

[revnice]

Thanks! As long as I can keep sticky fingers out of my work

[TheShabz]

np. please mark the thread as solved so that your question can be useful to others.

take care.

[pbaldy]

You might also consider distributing an mde/accde to users, which will prevent them from changing form/report designs or viewing code.

[revnice]

Thanks but it's my first day, I have no idea what I'm doing...or what that is.

[pbaldy]

You'll find the Access help system to be a valuable tool. There's a lot of info on these there.