Posts Tagged ‘#access’

HD revisited

Helpful Hints, News | Posted by Dennis June 15th, 2012

High definition, right?  Nope, in this case I’m talkin’ about Hard Drives.  I’ve written posts about the drive shortage, backing up, and solid state drives.  But there’s a whole new fleet of External USB (or networked) drives that deserve a closer look.  Several companies are making drives that you plug in and can access from all over the planet.  Others create their own WiFi network that you can log into from smartphones or your PC.  There are also some very stylish drives that are much smaller these days.  I have clients that will buy several pocket-sized drives and rotate them for offsite backup.   They also have some really tough built HD’s that can withstand a lot of abuse.  This would be perfect for industrial sites or college students :-)    Here’s an article  that shows them in detail (thanks to Marc Saltzman at Digital Crave).

Remote Access

Helpful Hints | Posted by Dennis February 3rd, 2011

There are lots of ways to control your work PC from home, or vice-versa.  We used to run PC-Anywhere or Windows Remote Desktop (WRD).  Both are decent solutions and give you full control over your remote PC.  But they can be tricky to set up and secure properly.  For example, WRD requires the host PC to have the PRO version of Windows installed, and you need to know the WAN IP address.  Another problem is that your router will need some tweaking, and that intimidates a lot of people.  A GREAT new solution is Teamviewer.  It’s free for personal use, and can be set to ONLY allow your other PC to control it.  It works on port 80 (same as browsing) so no router or firewall configuration is necessary.  Our biggest client bought a license ($800) for us, and we remote in to locations all over the US.   If you install it, be sure to set up a WHITELIST to prevent hacking.

Databases

Helpful Hints | Posted by Dennis January 28th, 2011

What’s a database (DB)?  It’s a way to organize information so that it can easily be viewed, organized, and accessed.  It allows you to keep track of all the relationships between each piece of data (so they’re sometimes called RELATIONAL databases).  Most PC users are already using a “canned” DB of some type or another.  Financial software for your books or taxes are a common example.  But did you know you can create your own?  MS Access or OpenOffice Base are two database programs that allow you to create ANY kind of database you want, from Movie Collections to Recipes.  A lot of small businesses start by building Excel spreadsheets or Word templates for all their common documents (invoices, etc.) but this can quickly get out of hand once they have a lot of customers.  That’s a good time to change to a database.  They’re designed to handle HUGE amounts of data with minimum clutter and maximum tracking.  There are almost ALWAYS a pre-made, or canned, version of DB’s for any type of business or activity you can imagine, but if you have the time, or know a good tech, it’s better to build your own.  Then you get EXACTLY what you want/need instead of conforming to some programmer’s ideas.