[OFF TOPIC] MS Access for Reports

Yahoo Archive
1
No, I simply protect it with Access Security and Network Security.
Users are not allowed into design mode on any of the objects in the
DB. How would splitting make it more secure for you? You're merely
putting the data on the server and the forms and reports that make up
the front on end on the clients. I know it goes against the common
practice, but I've always thought it is much easier to administer
when I'm dealing with a single file in a single location. I've been
designing and administering Access DB's for about 6 years and have
yet to have a problem with the way I'm doing it.

Brian

--- In vantage@yahoogroups.com, "joeyloken" <joeyloken@y...> wrote:
> Thanks a lot, Brian! It's always nice to know someone proficient at
> Access! Question for you: If you don't split the db, what do you
do
> to protect it? Do you put the .MDE file out on the network then??
> Joey Loken
> Brenton Engineering
>
>
> --- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
> wrote:
> > Joey,
> >
> > I use Access a lot, but I've never split the DB, so I've never
> > experience this problem, all of my DB's are on the network.
> >
> > Sorry I can't help with this, but if you have other Access
related
> > questions I'd be glad to lend assistance if I can.
> >
> > Brian Stenglein
> > Clow Stamping Co.
> >
> > --- In vantage@yahoogroups.com, "joeyloken" <joeyloken@y...>
wrote:
> > > Does anyone use an MS Access db for reporting purposes?
> > >
> > > I was thinking about using ODBC for setting up an Access db
that
> > > would hold some reports. I split my db but when I move the
> back_end
> > > to the network server, my computer freezes and the processor
> shows
> > > 100% usage. Why does this happen? Is it our network? I have a
> 100MB
> > > NIC and am on a 100MB hub. Got any ideas??
> > >
> > > Joey
2
Does anyone use an MS Access db for reporting purposes?

I was thinking about using ODBC for setting up an Access db that
would hold some reports. I split my db but when I move the back_end
to the network server, my computer freezes and the processor shows
100% usage. Why does this happen? Is it our network? I have a 100MB
NIC and am on a 100MB hub. Got any ideas??

Joey
3
Joey,

I use Access a lot, but I've never split the DB, so I've never
experience this problem, all of my DB's are on the network.

Sorry I can't help with this, but if you have other Access related
questions I'd be glad to lend assistance if I can.

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "joeyloken" <joeyloken@y...> wrote:
> Does anyone use an MS Access db for reporting purposes?
>
> I was thinking about using ODBC for setting up an Access db that
> would hold some reports. I split my db but when I move the back_end
> to the network server, my computer freezes and the processor shows
> 100% usage. Why does this happen? Is it our network? I have a 100MB
> NIC and am on a 100MB hub. Got any ideas??
>
> Joey
4
Thanks a lot, Brian! It's always nice to know someone proficient at
Access! Question for you: If you don't split the db, what do you do
to protect it? Do you put the .MDE file out on the network then??
Joey Loken
Brenton Engineering


--- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
wrote:
> Joey,
>
> I use Access a lot, but I've never split the DB, so I've never
> experience this problem, all of my DB's are on the network.
>
> Sorry I can't help with this, but if you have other Access related
> questions I'd be glad to lend assistance if I can.
>
> Brian Stenglein
> Clow Stamping Co.
>
> --- In vantage@yahoogroups.com, "joeyloken" <joeyloken@y...> wrote:
> > Does anyone use an MS Access db for reporting purposes?
> >
> > I was thinking about using ODBC for setting up an Access db that
> > would hold some reports. I split my db but when I move the
back_end
> > to the network server, my computer freezes and the processor
shows
> > 100% usage. Why does this happen? Is it our network? I have a
100MB
> > NIC and am on a 100MB hub. Got any ideas??
> >
> > Joey