Database DEsign Nightmare

[Stu Johnston]

Ok, I'm trying to design a database for work and need to know if (A) it is
possible and (B) how to do it.
Heres the general idea.

-Employees login to the database from various places around the country
-they need to be greeted with something that requires them to identify
themselves and a password( something to restrict their access)
-they then need to be able to edit/maipulate the data concerning their
clients(btu their clients only!), print reports, etc...
-finally, the manager needs to be able to print reports and view data for
all employees concerning thir clients

thank you and God bless you if you can help me, i am banging my head against
the wall right now!!

--Stu

 

[TP via AccessMonster.com]

A) It is possible

B) There are two ways (at least)
1. Use MS Access as the Front End and SQL Server or MS Access as a back
end. Back end must be on a server machine with high speed Internet access.
2. Internet Explorer as a Front End. Back end is the same like in 1).

 

[tw]

I think that only a portion of you question was answered. I'll try not to
step on the answers you already were given... But I'll attempt to answer
some of you request.

As far as having employees have access to their clients and only their
clients then you will need to put into the client table, and all other
tables that they may edit that are not related to the client table, a
UserName field so that when an employee adds a client, that client will be
assigned to that employee by saving the currentuser() to that field. When
user who is not a member of the "Managers" group, then you filter the report
to the UserName = CurrentUser(). When the managers run the report, run it
with no filter. Set up queries for the forms so that when a user pulls up a
form the query restrict the clients available to those for that user
specifically.

As far as the basic security set up groups, users etc. Check out security
for access database here.
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

 

[John Nurick]

Hi Stu,

A standard Access database is not suitable for use on a wide-area
network (WAN). For why, and alternatives (most using Access as the front
end), see Albert Kallal's article at
http://www.members.shaw.ca/AlbertKallal/Wan/Wans.html.

Access and all the other solutions Albert describes have the ability to
require log-ins and restrict access to data. The general idea is that
every user has to log in with a username and password. You define "user
groups", and assign each user to one or more groups. Then, for each
table, query, report, etc. you define which groups have what rights. The
details of how to do this depend on which database engine you end up
using



On Thu, 26 May 2005 11:30:03 -0700, Stu Johnston <Stu

 

[Stu Johnston]

Can I do this without being able to code in VisualBasic? I have a moderate
grasp of Access, but I definitly don't know how to code anything.

Thanks again!
Stu