"paii" <pa**@packairinc.com> wrote in message
news:vp************@corp.supernews.com...
Try splitting your database into a front and back end. You could then make
the back end read only and give each user a copy of the front end.
"Ahmed" <al******@yahoo.com> wrote in message
news:9d**************************@posting.google.c om... I'm trying to find a way to prevent users from editing the contents of
tables within my MS Access 2000 database. I want them to be able to
create queries, but not alter the data. I thought about making the
database file read-only, but then they would not be able to save their
queries. Any help would be appreciated. Thanks.
Ahmed
I was just going to say that if Ahmed wants to let his users create any
queries they like, then the only sensible solution would be to implement
Access user-level security. While I still maintain this might be the best
solution for someone who understands how Access security works, the
suggestion of a read-only back end might be perfect for someone who does not
want to implement user-level security (although I have never used this
approach).
P.S.
I am curious as to why you never post your name - are you connected to
packairinc.com? I went to
http://www.packairinc.com/pdf/news.pdf and saw
your Accounts Department but guessed you weren't one of them. Not that
there is any great need to know, but having posted a number of decent
answers, you might might want to at least put your first name.
Fletcher