By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,459 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

Locking Tables Against Edits

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
al******@yahoo.com (Ahmed) wrote in message news:<9d**************************@posting.google. com>...
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


Why not apply a top values query to this one? Or just look up Top
Values in the help...
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
"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

Nov 12 '05 #4

P: n/a

"Fletcher Arnold" <fl****@home.com> wrote in message
news:bn*********@sparta.btinternet.com...
"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


Yes I am with packairinc.com.
When I subscribed to this group I used paii and just never got around to
changing it.
Nov 12 '05 #5

P: n/a
"paii, Ron" <pa**@packairinc.com> wrote in message
news:vp***********@corp.supernews.com...

Yes I am with packairinc.com.
When I subscribed to this group I used paii and just never got around to
changing it.

OK - Hi Ron

Fletcher
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.