Re: question 2 on security

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: joe (joe_at_discussions.microsoft.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 16:06:01 -0700

Thanks for the informative website..i will follow it.In regards to server space and compacting? How much does compacting really do? The transactions would be the equivalent of about 150 transactions daily with five fields used.With time, it will get large so is there an option to 'dump' or backup data from the tables, burn em on cd then remove all data to start again?This idea may extend to others in the department since they handle different requests and it is a major change of how work is done.Thanks for all your help

"Joan Wild" wrote:

> How big is the backend? I can't imagine that the backend would be that
> large with three people tracking credit requests.
>
> You could perhaps enlist the three people in your approach to IT. Their
> jobs will be affected without the database, right?
>
> Also ensure that you routinely compact the backend. Since you are posting
> in the security group, and have already asked some questions about security,
> you should know that you shouldn't run the splitter wizard on a secure
> database. That will result in a secure frontend and unsecure backend.
> Follow the steps at
> http://www.jmwild.com/SplitSecure.htm
>
> --
> Joan Wild
> Microsoft Access MVP
>
> "joe" <joe@discussions.microsoft.com> wrote in message
> news:C17EB153-8851-42A2-B300-ECB71A95B2E6@microsoft.com...
> > I want to split my DB using front end/back end design...forms and reports
> on users desktops,,tables in server.The itd group has stated only a limited
> amount of space is reserved per department on the server.This DB is used to
> track credit requests and without the three people being joined to the same
> tables to run reports and run queries, the purpose would end up useless in
> tracking all these requests.Are there any options to this scenario or have i
> hit the wall with this idea and i am at the mercy of the itd group?thanks
> for the shoulder to cry on,,,,,,,,
>
>
>

Quantcast