Re: Self closing DB

Hi,
I once bought 2 almost identical PCs, one for office, this one was switched all the time (kind of server), other for home, which we shut down at night. first one had HDD crash, all fans was replaced, other still works fine.

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message news:e%23eO7jyOHHA.5104@xxxxxxxxxxxxxxxxxxxxxxx
Some people also argue that components are most likely to fail when they're starting up or shutting down, so not shutting down can extend the life. I've seen articles claiming that "if you're going to turn if off, and then back on in n hours, you're better off leaving it on" (with varying values for n)

Not sure whether I buy those arguments either.

I hybernate my machine when I go home at night (and shut it down every weekend).


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:uX9bUdyOHHA.5000@xxxxxxxxxxxxxxxxxxxxxxx
Agree, I saw this in big companies, the only explanation I found - the time employee has to wait while PC starts is much more expensive, then electricity cost for running this PC whole night :-))

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"Luis" <Luis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F521E5EB-A3C7-46EA-97E9-5E8EBFACD0E4@xxxxxxxxxxxxxxxx
Thats how i try to do this.
About the question of the energy cost, i'm from Portugal and the energy is
very expensive. Fortunately the company where i work is the biggest company
of Portugal and the profits are enough to pay these kind of waste. I
personnaly shut down my pc every day.


"Douglas J. Steele" wrote:

Hopefully all of your applications are split into a front-end (containing
the queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relationships). Only the back-end should be on
the server: each user should have his/her own copy of the front-end, ideally
on his/her hard drive.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Luis" <Luis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6DA5458C-94B3-403B-B8B5-ADE7E0E27768@xxxxxxxxxxxxxxxx
> Thank you all for the quick solution.
> On my company there are lots of users that dont close the > applications
> when
> they go home. Unfortunatelly for me and some more application > developers
> that
> need to update some data at night and sometimes some users let the
> databases
> opened exclusivelly.
> This is my day to day struggle and i hope i win some day.
>
> Thanks
>
> "Baz" wrote:
>
>> You would need to base this on a form's timer event. If you have >> some
>> kind
>> of splash or background form that stays open throughout, you could >> use
>> this.
>> Alternatively, you could have a hidden form which opens on startup >> and
>> remains open.
>>
>> You could have the timer event check the time every minute or >> whatever
>> or,
>> if you wanted to be clever and save precious CPU cycles, when the
>> abovementioned form opens you could have it check the time and >> calculate
>> the
>> timer interval so that it only fires once, at the appropriate time >> to say
>> goodnight.
>>
>>
>> "Luis" <Luis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:74B02B15-F0A5-4407-B172-759EE7331F0F@xxxxxxxxxxxxxxxx
>> > Hello.
>> > I have a database that i need to close after working hours.
>> > The idea i'm thinking is to create a process that checks the hour >> > and
>> > if
>> its
>> > between 11pm and 12pm the database closes.
>> >
>> > How can i do something like that?
>> >
>> > Thanks
>> >
>> > Luis
>>
>>
>>







.

Relevant Pages

  • Re: Running a query on the Back End
    ... When a user opens Datapart it is the same as the BE, ... > the server, or even in the folder, where the Back End resides. ... I make one field in the Settings ... > know how to use the timer event except on forms. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Is this an easy fix or complicated one?
    ... that box that opens, properties will be listed..if it isn't working, post ... >> within the required timeout. ... The server %1 did not register with DCOM within the required ... >> If the problem continues to occur, contact the program vendor. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Email attachments fom one user can not be opened on SBS server
    ... Attachments from other users outside of the office come through fine. ... and they seemed to open okay except at one other location that also has SBS ... the Small Business Server, then have the user send the email again. ... If her email is sent to me, then I forward it to the SBS server it opens ...
    (microsoft.public.windows.server.sbs)
  • Re: Email attachments fom one user can not be opened on SBS server
    ... Attachments from other users outside of the office come through fine. ... We had her send emails to test addresses at other customer sites and they seemed to open okay except at one other location that also has SBS 2003 and Symantec Antivirus. ... The same thing happens if you open it with word viewer on the server or Word 2003 on the workstation. ... If her email is sent to me, then I forward it to the SBS server it opens OK. ...
    (microsoft.public.windows.server.sbs)
  • Re: Email attachments fom one user can not be opened on SBS server
    ... Attachments from other users outside of the office come through fine. ... We had her send emails to test addresses at other customer sites and they seemed to open okay except at one other location that also has SBS 2003 and Symantec Antivirus. ... The same thing happens if you open it with word viewer on the server or Word 2003 on the workstation. ... If her email is sent to me, then I forward it to the SBS server it opens OK. ...
    (microsoft.public.windows.server.sbs)
Loading