I.T. Discovery

Providing professional, honest, ethical service and advice of the highest quality, focusing on customer satisfaction.

ESET. The Security Solution Leaders.

Proven, trusted security. Bringing you award-winning products year after year.

I.T. Discovery - Anything and Everything Computer

Servers, Home-PC\'s, Printers, Laptops, Networking Equipment, UPS, Software - All the leading Brands directly to your door.

***SPECIAL ELITE HP LAPTOP*** WHY BE “JUST GOOD ENOUGH” – WHEN YOU CAN BE ELITE

***!!!HP ELITEBOOK FOLIO with 8GB RAM $1125 inc GST AND Delivery!!!***

***UNBEATABLE***

 

This offering from hp brings the best in elegant design coupled with blistering performance – SSD (Solid State Drive) means faster boot time and program loads. 8GB RAM (4gb more than others can offer) means you can run more of the programs that your business or schooling may need.

CONTACT US NOW – Limited Stock Available – see specs below.

Description: HP EliteBook Folio 9480m
* Intel® Core™ i5-4210U (1.7 / 2.7 GHz)
* 8GB DDR3L 1600MHz Memory
* 256GB SSD Hard Drive
* 14″ HD LED Display
* Integrated Intel® HD 4400 Graphics
* DisplayPort, VGA
* 3 x USB 3.0
* Gigabit Ethernet
* 802.11abgn+ac Wireless, Bluetooth 4.0
* Smart Card Slot, SD Card Reader
* HD Webcam, Fingerprint Reader
* Backlit Keyboard
* Microsoft Windows 7 Professional 64bit
+ Microsoft Windows 7 Professional 64bit Media
+ Microsoft Windows 8 Professional 64bit Media
* 3 Year Onsite Warranty
* Note: This model has no optical drive
Shipping Weight: 2.76 kg
Height: 310 mm
Length: 560 mm
Width: 75 mm
Volume: 0.013 m3
Product Image
Product ImageProduct ImageProduct Image

Multi Tenant Database using Microsoft ACCESS!!! – Take your legacy apps to the masses.

In a recent project that was undertaken a challenge was presented. “We have an access database application that we currently install on end users machines, but we want to move it to a cloud based service”

The software was a split access database, usually only one organisation can access the relevant access database backend front a distributed frontend. There was a direct one-to-one relationship between the host windows machine and the database for the organisation… IE each organisation needed to have a dedicated machine – be it on premise or hosted service. This involved either ongoing maintenance and troubleshooting of dissimilar hardware/software environments or costly windows server hosted solutions.

This was before I.T. Discovery was involved…

By utilising MS Terminal Services and Active Directory, we were able to craft a server that is able to host MULTIPLE MS ACCESS databases. Each organisation has its own database and accesses the front end via Terminal Services Remote Desktop. Within this managed environment, the deployment of new organisations is a snap, adding new users via a scripting mechanism.

Here is the impressive part:-

  • We have successfully hosted OVER 170+ Access Databases consisting of OVER 400 individual users.
  • There is anywhere up to 15+ concurrent users accessing a single access database.
  • The Access app is now “CLOUD BASED” allowing any RDP enabled device to connect.
  • The TS server has been able to support up to 100 concurrent users.
  • This has all been achieved ON A SINGLE SERVER 2008 R2 MACHINE.

Server Specs

6 core CPU

32GB RAM

Raid 5 Disk Array Currently 700GB

10m/bit internet link

The interesting thing noted about this deployment is that it is definitely not the cpu or hdd resources limiting more concurrent users, we hit the 32gb ram ceiling with around 110 concurrent users with this memory footprint per user. With more memory (Server Enterprise) this solution is SCALEABLE.

  1. MSACCESS APP – 50-100mb
  2. LIVE MAIL 150MB (since removed allowing MORE concurrent users)
  3. SYNCDOCS 60MB

To achieve this with a SQL mutliple tenant environment, each instance of SQL server would have required an even very conservative 1gb, this limits the server to 32 organisations.

All in all the JET database engine is very efficient and fast when accessing data LOCALLY, the important this is keeping the front and back ends physically on the same machine and avoiding any network type access.

Has anyone actually read the review for the NBN and it “fixed wireless” ???

Has anyone actually read the review for the NBN and it “fixed wireless” lets go get a “Sharp Stone/Blunt Stone” to cure our headaches. Check the CIR WOW a committed rate of just below 10 times good ‘ol dialup

9.2 Fixed wireless technology choices
From a technology perspective, the Review found that NBN Co has been prudent in terms of
making choices around technology, network design, and engineering, in order to meet its product
requirements. Specifically:
• TD-LTE is a standardised technology with a clear roadmap. Its fundamental characteristics
make it suitable for a fixed wireless deployment requiring asymmetric downlink and uplink
• Base station equipment is generally off-the-shelf but reconfigured for specific requirements
• A design parameter of 500/150kbps Committed Information Rate (CIR) for all fixed
wireless premises can deliver a satisfactory end-user experience for a product with Peak
Information Rate (PIR) of 25/5Mbps
• By using outdoor wireless network termination units (WNTDs) at the premises with near
line-of-sight to the fixed wireless tower, NBN Co can deliver the required performance
level, and satisfactory cell coverage to address 20 percent of the area within 14km radius
• The WNTDs are fine-tuned to maximise performance (e.g. uplink power level is 1dB above
3GPP standards)

Creating a Custom icon for MS Access VBA Program

For example, to launch an application named My DB.mdb on C:\ root, open properties of a shortcut then put this command line in the target :
“C:\Program Files (x86)\Microsoft Office 20XX\OFFICE1X\MSACCESS.EXE” “C:\My DB.mdb”
Modify x to fit with your MS Office version. Finally, change shortcut icon.

When you run this shortcut, your MS Access application runs in a separated group of you W7 taskbar that shows your own icon.

You can totally automise this process with a CreateShortcut Windows API from vb and detect automatically MS Access executable to get a professional issue.

Windows Keyboard Shortcuts – When your mouse is squeaked

Windows system key combinations

  • F1: Help
  • CTRL+ESC: Open Start menu
  • ALT+TAB: Switch between open programs
  • ALT+F4: Quit program
  • SHIFT+DELETE: Delete item permanently
  • Windows Logo+L: Lock the computer (without using CTRL+ALT+DELETE)

Windows program key combinations

  • CTRL+C: Copy
  • CTRL+X: Cut
  • CTRL+V: Paste
  • CTRL+Z: Undo
  • CTRL+B: Bold
  • CTRL+U: Underline
  • CTRL+I: Italic

Mouse click/keyboard modifier combinations for shell objects

  • SHIFT+right click: Displays a shortcut menu containing alternative commands
  • SHIFT+double click: Runs the alternate default command (the second item on the menu)
  • ALT+double click: Displays properties
  • SHIFT+DELETE: Deletes an item immediately without placing it in the Recycle Bin

General keyboard-only commands

  • F1: Starts Windows Help
  • F10: Activates menu bar options
  • SHIFT+F10 Opens a shortcut menu for the selected item (this is the same as right-clicking an object
  • CTRL+ESC: Opens the Start menu (use the ARROW keys to select an item)
  • CTRL+ESC or ESC: Selects the Start button (press TAB to select the taskbar, or press SHIFT+F10 for a context menu)
  • CTRL+SHIFT+ESC: Opens Windows Task Manager
  • ALT+DOWN ARROW: Opens a drop-down list box
  • ALT+TAB: Switch to another running program (hold down the ALT key and then press the TAB key to view the task-switching window)
  • SHIFT: Press and hold down the SHIFT key while you insert a CD-ROM to bypass the automatic-run feature
  • ALT+SPACE: Displays the main window’s System menu (from the System menu, you can restore, move, resize, minimize, maximize, or close the window)
  • ALT+- (ALT+hyphen): Displays the Multiple Document Interface (MDI) child window’s System menu (from the MDI child window’s System menu, you can restore, move, resize, minimize, maximize, or close the child window)
  • CTRL+TAB: Switch to the next child window of a Multiple Document Interface (MDI) program
  • ALT+underlined letter in menu: Opens the menu
  • ALT+F4: Closes the current window
  • CTRL+F4: Closes the current Multiple Document Interface (MDI) window
  • ALT+F6: Switch between multiple windows in the same program (for example, when the Notepad Find dialog box is displayed, ALT+F6 switches between the Find dialog box and the main Notepad window)

Shell objects and general folder/Windows Explorer shortcuts

For a selected object:

  • F2: Rename object
  • F3: Find all files
  • CTRL+X: Cut
  • CTRL+C: Copy
  • CTRL+V: Paste
  • SHIFT+DELETE: Delete selection immediately, without moving the item to the Recycle Bin
  • ALT+ENTER: Open the properties for the selected object

To copy a file

Press and hold down the CTRL key while you drag the file to another folder.

To create a shortcut

Press and hold down CTRL+SHIFT while you drag a file to the desktop or a folder.

General folder/shortcut control

  • F4: Selects the Go To A Different Folder box and moves down the entries in the box (if the toolbar is active in Windows Explorer)
  • F5: Refreshes the current window.
  • F6: Moves among panes in Windows Explorer
  • CTRL+G: Opens the Go To Folder tool (in Windows 95 Windows Explorer only)
  • CTRL+Z: Undo the last command
  • CTRL+A: Select all the items in the current window
  • BACKSPACE: Switch to the parent folder
  • SHIFT+click+Close button: For folders, close the current folder plus all parent folders

Windows Explorer tree control

  • Numeric Keypad *: Expands everything under the current selection
  • Numeric Keypad +: Expands the current selection
  • Numeric Keypad -: Collapses the current selection.
  • RIGHT ARROW: Expands the current selection if it is not expanded, otherwise goes to the first child
  • LEFT ARROW: Collapses the current selection if it is expanded, otherwise goes to the parent

Properties control

  • CTRL+TAB/CTRL+SHIFT+TAB: Move through the property tabs

Accessibility shortcuts

  • Press SHIFT five times: Toggles StickyKeys on and off
  • Press down and hold the right SHIFT key for eight seconds: Toggles FilterKeys on and off
  • Press down and hold the NUM LOCK key for five seconds: Toggles ToggleKeys on and off
  • Left ALT+left SHIFT+NUM LOCK: Toggles MouseKeys on and off
  • Left ALT+left SHIFT+PRINT SCREEN: Toggles high contrast on and off

Microsoft Natural Keyboard keys

  • Windows Logo: Start menu
  • Windows Logo+R: Run dialog box
  • Windows Logo+M: Minimize all
  • SHIFT+Windows Logo+M: Undo minimize all
  • Windows Logo+F1: Help
  • Windows Logo+E: Windows Explorer
  • Windows Logo+F: Find files or folders
  • Windows Logo+D: Minimizes all open windows and displays the desktop
  • CTRL+Windows Logo+F: Find computer
  • CTRL+Windows Logo+TAB: Moves focus from Start, to the Quick Launch toolbar, to the system tray (use RIGHT ARROW or LEFT ARROW to move focus to items on the Quick Launch toolbar and the system tray)
  • Windows Logo+TAB: Cycle through taskbar buttons
  • Windows Logo+Break: System Properties dialog box
  • Application key: Displays a shortcut menu for the selected item

Microsoft Natural Keyboard with IntelliType software installed

  • Windows Logo+L: Log off Windows
  • Windows Logo+P: Starts Print Manager
  • Windows Logo+C: Opens Control Panel
  • Windows Logo+V: Starts Clipboard
  • Windows Logo+K: Opens Keyboard Properties dialog box
  • Windows Logo+I: Opens Mouse Properties dialog box
  • Windows Logo+A: Starts Accessibility Options (if installed)
  • Windows Logo+SPACEBAR: Displays the list of Microsoft IntelliType shortcut keys
  • Windows Logo+S: Toggles CAPS LOCK on and off

Dialog box keyboard commands

  • TAB: Move to the next control in the dialog box
  • SHIFT+TAB: Move to the previous control in the dialog box
  • SPACEBAR: If the current control is a button, this clicks the button. If the current control is a check box, this toggles the check box. If the current control is an option, this selects the option.
  • ENTER: Equivalent to clicking the selected button (the button with the outline)
  • ESC: Equivalent to clicking the Cancel button
  • ALT+underlined letter in dialog box item: Move to the corresponding item