Re: Add a default form for start-up
From: SHIPP (SHIPP_at_discussions.microsoft.com)
Date: 11/08/04
- Next message: SHIPP: "Add a default form in the start-up options."
- Previous message: Jamie Collins: "Re: Running a macro in excel"
- In reply to: Andy: "Re: Add a default form for start-up"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 8 Nov 2004 07:10:03 -0800
Guys, I work for a Fortune 50 company. They want an absolute fool proof way
of no one getting to someone elses data based on the Sarbanes-Oxley Act. This
is a directive of the CEO as well as the Big 5 Accounting company that audits
them. The ONLY way to accomplish this is through separate and distinct
databases. I would certainly appreciate someone answering my original
question. Thanks in advance.
"Andy" wrote:
> It seems to me the startup options would be the same for each database. The
> only difference being which BE is connected. I maintain 7 timeticket
> databases, each identical in the FE version. The difference being which BE
> they are connected too.
>
> But I agree with the previous reply. It seems with a little security
> enforced, you could easily limit access to the sensitive data, as I had to
> do with my time ticket database.
>
> Make the sensitive data not readable by anyone except the db Administrator.
> Use queries to access the data with owner access via the forms.
>
>
> hth,
> Andy
>
>
> "SHIPP" <SHIPP@discussions.microsoft.com> wrote in message
> news:B9BA722B-9E75-4175-83B0-ED4A481B6EC7@microsoft.com...
> > The main database has very sensitive material in it. Each manager is only
> > allowed to see the data pertaining to their department. The individual
> > databases are changed/updated and returned where I then bring the
> new/changed
> > data back into the main database. Does anyone have an answer for my
> original
> > question?
> >
> > "Richard Hollenbeck" wrote:
> >
> > > SHIPP,
> > >
> > > Are you actually splitting the database into 70 separate databases to be
> > > maintained separately or does each manager daily query the main database
> to
> > > work on a subset of the data? It seems to me a lot of extra work to
> > > maintain 70 databases rather than just having each manager do a daily
> query
> > > of the main database to get a copy of each manager's data, then the
> managers
> > > can do daily updates of the main table at the end of each session. Am I
> > > reading your question wrong? I would think the daily query would depend
> on
> > > which manager is logged-in regardless of the particular machine the
> manager
> > > happens to be using. But I'm not a network guy so I'd better shut-up.
> I'm
> > > interested to read whatever answers you get to your very interesting
> > > question.
> > >
> > > Rich Hollenbeck
> > >
> > > "SHIPP" <SHIPP@discussions.microsoft.com> wrote in message
> > > news:F367A0D4-7589-49B1-B0AF-886D40EB9797@microsoft.com...
> > > > I am writing the code to break an employee database down into 70
> separate
> > > > databases (one for each manager containing their employees only). This
> is
> > > > going just fine. What I need to know is how do I set the start-up
> options
> > > in
> > > > a database that is different from the one I am currently working in.
> > > Thanks
> > > > in advance.
> > > > --
> > > > M. Shipp
> > >
> > >
> > >
>
>
>
- Next message: SHIPP: "Add a default form in the start-up options."
- Previous message: Jamie Collins: "Re: Running a macro in excel"
- In reply to: Andy: "Re: Add a default form for start-up"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
