|  | disabling records in a table/query | | |
| | | Jomark |  |
|  Posted: Mon Sep 01, 2008 10:18 am Post subject: disabling records in a table/query |  |
Is it possible to disable records in Access in a table/query similar to
Protection in Excel such that some records are read only whilst the others
are able to be edited? |
| |
| | | Pete D. | |
| | Posted: Mon Sep 01, 2008 11:51 am Post subject: Re: disabling records in a table/query | |
No,the users should not see the tables or queries especially if you need to
protect the data. Present the data in forms and reports to the user and
protect the fields using the forms/reports.
"Jomark" <Jomark@discussions.microsoft.com> wrote in message
news:1A78899F-8485-468D-8F6C-1724395D1AF7@microsoft.com...
| Quote: | Is it possible to disable records in Access in a table/query similar to
Protection in Excel such that some records are read only whilst the others
are able to be edited?
|
|
| |
| | | Dominic Vella | |
| | Posted: Mon Sep 01, 2008 10:21 pm Post subject: Re: disabling records in a table/query | |
Right click on the tables, select properties and tag the 'Hide' checkbox.
Anything else is really better done with SQL server.
Dom
"Jomark" <Jomark@discussions.microsoft.com> wrote in message
news:1A78899F-8485-468D-8F6C-1724395D1AF7@microsoft.com...
| Quote: | Is it possible to disable records in Access in a table/query similar to
Protection in Excel such that some records are read only whilst the others
are able to be edited?
|
|
| |
| | | Linq Adams via AccessMons | |
| | Posted: Tue Sep 02, 2008 12:09 am Post subject: Re: disabling records in a table/query | |
As has been suggested, all user access to records should be by way forms only.
Doing that, you can set properties of either the form or individual controls
so that some records can be conditionally locked.
--
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
LINK |
| |
| | | magmike | |
| | Posted: Tue Sep 02, 2008 2:30 am Post subject: Re: disabling records in a table/query | |
| |  | |
On Sep 1, 9:09�pm, "Linq Adams via AccessMonster.com" <u28780@uwe>
wrote:
| Quote: | As has been suggested, all user access to records should be by way forms only.
Doing that, you can set properties of either the form or individual controls
so that some records can be conditionally locked.
--
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access/200809/1
|
If you want individual records from a table to be locked while others
from the same table are not, and you do go the route suggested above,
by hiding tables and queries from your users and using forms to
display the data, you could do the following:
1. Create a Yes/No field in your table called "Private" or "Locked" or
something. When a record is created you can choose to mark it "Locked"
by checking a check box on your form.
2. Code your form to disable (but still display the data) the fields
based on the "Locked" field. For example:
In the OnCurrent of your form,
If Me.LockedField = True Then
Field1.Enabled = False
Field1.Locked = True
Field2.Enabled = False
Field2.Locked = True
End If
I may not have this code exactly right, but that is the idea. Using
this strategy, when your user is viewing records, they could edit
data, unless the record has the "Locked" record field checked. Of
course, you will either want to ensure that the "Locked" field is
either hidden, or also locked and disabled if checked.
magmike
(just a hack, but trying to help) |
| |
|
|
