If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access database help
How can I keep the sales people from changing my database; only allowing them
to access inventory and enter parts they sold, and automatically update parts on hand. |
#2
|
|||
|
|||
Gthebigt,
I usually find that threatening to break their legs works pretty well. Failing that, I guess the general principle here is to design your application in such a way that they can only edit data that they are allowed to. I assume that the sales people are using a different computer than you? If so, one approach is to make two frontend files, one for you and one for them. On theirs, you will only use forms that provide access to the data that is relevant to them. First of all, you will restrict it by excluding any tables and fields that are not relevant to them. And then you can restrict it further, in the case of data that they need to be able to see but not change, by one of two general approaches... First by setting as applicable, the AllowAdditions and AllowEdits and AllowDeletions properties of the forms. Second by setting as applicable, the Enabled and Locked properties of the individual data controls on the forms. -- Steve Schapel, Microsoft Access MVP gthebigt wrote: How can I keep the sales people from changing my database; only allowing them to access inventory and enter parts they sold, and automatically update parts on hand. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 07:36 AM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 10:44 PM |
is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 10:20 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |