By definition in quite a few languages that I know of, sentences ending in a "?" are deamed questions. your answer and the other couple back in this thread are actually what I was looking for. I'm so sorry that people in this country are allowed to ask questions instead of just answer the question you want answered. Not necessarily offbase, but it isn't anyone else's fault that you inherited a poor design for the web, and you should look in to the "control" issues you obviously have.
-----Original Message----- From: Bakken, Kory [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 1:01 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Scheduled Datasource Updating Bruce: Yes. I inherited an Access DB that we are running a large intranet application against. It works fine for the 200+ users that use it, and it is actually faster than most of our counterparts that use an Oracle DB. However, it requires frequent maintenance. I know that no user will be using the application between midnight and 2am CST (since all users reside the same time zone), so "no" this is not a ridiculous solution, and "no" I am not worried about downtime. But thank you for the remarks (questions?). I hope I am not off-base when I say this, but in the future, if your reply is not helpful or positive, please refrain from making any comments at all. I just need to know if it is possible to schedule an update on a CF datasource using CF Administrator. Kory Bakken -----Original Message----- From: Dunwiddie, Bruce [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 12:19 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Scheduled Datasource Updating am I crazy, or this a rediculous solution in the age of providing worldwide services in all timezones? and I can only assume that this maintenance is necessary because you're using an access db? -----Original Message----- From: Ellis, Randy [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 11:40 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Scheduled Datasource Updating We have a scheduled BAT file running on our web server each night that updates a database file. The unfortunate thing is we actually down the website to perform the updates and then bring the website back up. The BAT file looks look this: net stop "WORLD WIDE WEB PUBLISHING SERVICE" C:\Update.exe net start "WORLD WIDE WEB PUBLISHING SERVICE" Randy -----Original Message----- From: Bakken, Kory [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 11:09 AM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Scheduled Datasource Updating I need to schedule maintenance window each night to perform automated repairs and compaction on my main database. I know how to do that, but in order to repair and compact the database, I need to disconnect the datasource that is hitting against it for that period of time. Does anybody know if it is possible to schedule updates to a datasource (i.e.-disconnect and reconnect)? Kory Bakken IT Enterprise Release Management Tools / Process desk: 816.559.4801 pcs: 816.305.5890 ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]