A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access database help



 
 
Thread Tools Display Modes
  #1  
Old March 5th, 2005, 12:37 AM
gthebigt
external usenet poster
 
Posts: n/a
Default 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  
Old March 5th, 2005, 04:53 AM
Steve Schapel
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 04:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.