Skip to content

Annual steps for S Bassage ESTEC DB

Around April or May, perform these steps.

  1. Open  frmBooking form, change the hard coded year , look in the vBeginID_AfterUpdate() function.
  2. Open the tblSchoolWeeks table and correct a couple records….the newly generated calendar weeks, specifically where the application generates a couple incorrect holiday weeks – because of the odd process that my customer does not follow correctly.  The past couple years, I have simply renumbered the weeks (2) that are not supposed to be there (the correct holiday weeks), to the weeks that are.
  3. Open form subFrmCheckin -look in  Form_load event, update hard coded date
  4. A new school year id has been generated and needs to be updated in a couple places.
  5.  Open frm_districts_building_kits_dates – open the query (rec source) for the unbound list box – change the schoolyearid.
  6.  – qryBooking2013-14 – leave the name, change the schoolyearid

You may also have to correct kit cost – that seems to use the older year price.  If this happens, follow these steps to correct kit booking cost issue

  1. open the kits table – ensure cost is up to date
  2. open the booking table to verify that booking for the new year are in there
  3. create a new query and use an update statement to correct cost that is wrong
  4. pull up the kits table, show just id and cost columns, hid the other columns
  5. next to the kits table – position the query window – so its easy to see both and scroll down the kits table.  Last year I also printed the kit booking records so i could see which kits actually needed to update.





Annual steps for S williams access DB

Perform these steps each april, until one of us retires.

constraints:  Using only MS Access 2003, not the much newer version of 2010 or 2013.  opening in newer version corrupts the db.

  1. copy the current year billing db from network home space to local folder called /old billing
  2. rename the db in network home space to following year
  3. kill the old shortcut on the desktop pointing to the previously named db
  4. create a new shortcut – browsing to the newly named db in network home space
  5. open the DB
  6. remove records from the transactions table
  7. update the date on the main form
  8. update the other form, not report, form – a form that loads when clicking on the Reports button – semantics!  Anyway, change the dates on the unbound form controls.

The end.


Remoting into and rebooting computer

For a while, I have been trying to figure out how to give my account permission to reboot a server remotely.  These server are running Windows 7.  The workstations are responsible for providing IP address and a connecting port for cameras.  Sometimes the cameras come off line, usually because Windows did an update and something did not come back on line.

Today, when we discovered some of the cameras down, I worked with a new network technician to resolve the issue.  He taught me this nice command line beauty:

shutdown – r

It took a minute – but, sure enough, I was logged out of my session and the server was rebooted, with a parameter to restart.

I guess as long as my account that I am remoting in with is of type admin, I can get to that command line and run any of the windows commands, like this one.

Now, when cameras are off line, I too can consume the low hanging fruit on the tree that usually corrects the problem, a restart of the server.  I do here my colleague saying in my minds ear, “some of these problems need me to be there to diagnose with a reboot not solving the issue”.  But, today, like most days, the reboot of the server brought the cameras back online in the network.




We are finally getting serious about upgrading our main website for our BOCES organization.  If you know what a BOCES is, you now there are a lot of considerations that go into the decision about who to upgrade to.

We are currently using a SchoolWorld solution, that belong to Blackboard.  We are considering upgrading to the SchoolWires solution, also from blackboard.  We are also looking into a company called Logisoft.  They would be the anti-establishment candidate, during this political season.  We can call Logisoft – BernieSoft – feel the Burn.

My view is how i will the existing content port over to a new system?  How will that be done, who will do it, what kind of migration does it look like, how long would it take, what would be our role?  My collegue, Shannon, who is the public information officer, looks at it like what other things does the service offer?  calendar syncing, sub-site options, mobile options, easy to use, training for the site users?, admin interfaces for our content champions?

As a BOCES, we have several other entities that exist within our organization, like two tech centers, one each in Williamson and Stanley NY.  Also, spec. education buildings in 4 different locations and a couple others.  All of which are part of the BOCES system.

The view from the seats looks like “how many of our sub-sites could be housed in the main site?”  In other words, do the special education building really need their own site?  Lets bring them into the fold, under the umbrella of the main BOCES site.  Create a sub space for them.  That would seem a better solution, as we are paying fewer renewal fees for DNSs and steamlining the process.

A problem with bringing the ed. centers under the umbrella would be sharing say a calendar or some other module that is already being used by the BOCES site.

I am going to make a comparative chart, that highlights certain items from each vendor.  That is also the view from the admin. level people at BOCES.  That want to know the summary data, total cost, fees, support, license etc.  Not as much in the way of detail.

One of the things we are doing is getting temp. admin accounts from both vendor, so we can look at that side of the site…although as i think about that, it will not be what makes the decision – that will be things on the front end – usage related things – that has more people interested.  I think, not sure.  The people who are admins are not really concerned about the interface or how to do things, they are more concerned with what can it do and how easy it is, intuitive.

Today, I discovered one of our districts, ironically, our local high school, were the BOCES is located, is using one of the two options we are considering, Blackboard SchoolWires.   Its a good change for me to look around a little more closely to see how different the service is from the old one, Blackboard schoolWorld option.  Additionally, there is another BOCES in our state that has upgraded to Blackboard SchoolWires, Naussa BOCES.  Another good place to look around a little.

I did notice in both Newark and Naussa Wires sites that they are using the Calendar module.  There are feeds avail to allow you to sync up devices like your phone or google calendar to the websites.  In other words, the Wires site is the provider of the calendar data.  A feed is created for consumer apps, like your phone or some other 3rd party consumer.  That is probably not big news for many, but I do not use the calendar much, but other seem to….



Both Wires sites have a calendar presence on their home pages.


web servers that I support…

And how to look at them differently.  Too much philosophy lately, has me looking at this stuff different too.  As it should.

The server(s).  Three of them in the web cameras system echosphere.  I like this view, good and global.

The server is part of a process that includes, software, people, hardware and communication.  When the software hiccups, meaning the people logging into it on a daily basis to monitor entrance ways, cannot log in or access – generates a big reaction.  A priority 1 for our helpdesk.  The helpdesk is another part of the system.

Philosophical view?  James should never be the sole person responsible for getting things done when the system goes down.  The critical information, whatever that is, needs to be shared and understood by the people in the system.  Makes sense.

A more pragmatic view is when the system is down, we need to communicate that with the right people as quickly as poss. so we can get the system back on line.

The system is responsible for creating 30 days worth of video footage for about 90 cameras on three different campuses.  That is a good global view of the system.  Three servers are responsible for archiving or keeping that footage around and accessible if necessary.  After 30 days, the space is recycled.  There are two dedicated archive servers in the system with hard drives of over a terabyte. – lots of storage needed for camera video.  A picture of the storage capacity of one of the archive servers.  Four drives, complete with a recovery drive.  Their space should remain consistent – meaning the storage requirement for the cameras for 30 days would not change unless more cameras were added or a high resolution option.


The Genetec software is also installed on the archive servers, not sure why, perhaps to assist in the management of the recorded video footage…?  not sure.  There is no configuration data associated with the software, I just loaded it up and it is empty.

The main server that does contain configuration information also uses Genetec software to assign cameras IP addresses so they can be visible via the Internet.  The main server also has a large capacity hard drive and archives video too.

One of  the things I tried to do last week in the system, was change the behavior of my remoting credentials, so my password would not change every 45 days or so.   I reset the passwords and shared the information with others in the system and would like for that not to change automatically.

Additionally, I wanted to have the same permissions and behaviors for each of the accounts associated with each server.  Namely, the ability to restart the server remotely.  Although, from a systematic or operational view, the last couple times the main server hiccuped from either a Windows update or something, our technition had to physically go to the site and reboot the server.  A remote session or a reboot would not solve the issue.  A service had to be reset or bad drive sectors needed correcting via a checkdsk command, for example.

While researching this, I discovered a neat windows command that allowed me to access properties of my account on the server.  Depending on the version of Windows on the server (Windows 7 or Windows server 2008), the command was  a little different, and the way the account was implemented was a little different, from server to server.  One used groups, the others did not.

So I am wanting two things – really one, a better understanding of what my account can do and why – philosophical.  Pragmatically speaking, I need to change the account password reset property and the permission.

The Windows command to access the user account properties is:

Another factor in the system that caused confusion was the arrival of the servers 18 months ago and not getting registered via another system.  Consequently, people in this system would be confounded about details of the server, locations etc.  I have pieced that information together over the past year and shared it with others in the system.  I also made a inquery – action diagram in attempt to provide direction in the system when certain things happen.


Another day, another view of

Security camera system, not software , but system.

I remoted into the main server this am, just to ensure the changes I had recently made to the credentials were in tact.

This system – cameras, ip addresses, software and server(s) and the people who use it are the system.  Yes, do not forget the people who use them and support them.

Turns out the server has a bit of capacity, especially in terms of drive space.


The system has 2 other video archiving servers, now i understand that the main server also archives video.  Why else would there be a 1.8 Terabyte drive in the server?  There is also a recovery drive (F) – that is about 8 GB.  I am sure that would have been used IF we had to replace that C drive last week.  A new 455 GB drive would have been installed and the 8 GB recovery drive would have been mirrored or ghosted to the new drive.

Additionally, I noticed in the systray an icon.  Clicking it opened the server Control Panel.  It is telling me a couple things about the Security and Maintenance settings.


This server is not in our network, so the firewall is turned off.  The update is turned off too, maybe because updates in the past have caused the server to go down, or at least the video camera services.  No virus protection either.  This server does not broadcast itself and its ip address nor does it have people use use it to browse the internet.  Nothing.  Only run the software and store 30 days worth of recordings from 40 cameras.

The Maintenance settings are less interesting, but still there, especially the backup.  Windows want to make it easy for admins of the server to back it up and whatever may be installed on it.

Early morning AHA?

The web camera system has a large number of components.  Servers – with lots of drive space, software on the servers configuring and connecting IP addresses to specific cameras, storage of video from the cameras, processes, like the one that recycles drive space after 30 days stored on a drive, people who use the system in different roles, server admins, software admins, managers – to communicate things, monitors, people who watch the cameras, especially the doors.


New printers mess up report settings

My customer says to me, “James, we got a new copier installed and now the labels in report so and so do not print correctly”.  I have heard this tune before.  The last time they changed copiers/printers, a similar thing happened.

I went over to her site, since I needed to see the labels and test them while making corrections to the report properties in Access.

I logged into the system, pulled up the report in question, made a small change to the layout properties and printed a sample sheet, just one page, so I only waste a single page of labels.  This verified I was in the correct report – ya never know – I used to say I am ensuring that I am “digging around in the right hole”….

Upon verification, I noticed that my customer had attempted to correct the problem, which I appreciated, I appreciated even more that fact that she mad a copy of the report first.  I deleted the report she had been playing with, as it was pretty bad, made a new copy of the report and started from a fresh copy – only after I had made a fresh backup of the report did I start tweaking properties of it.  A fall back plan in the unlikely event that I get discombobulated😉.
After about 15 minutes of tweaking the report, I was able to correct the problem by changing the size of the controls on the report and moving them a little.

All systems go.

Moral of the story?  Make a backup of the original before changing it and test your changes in small pieces – or print a single page of data to minimize wasting of labels.


Get every new post delivered to your Inbox.