jinnantonnixx

As it happens, here's a snippet from an application I wrote a while ago. "perms" is the junction table It also binds a drop-down to a data source. I should add that I used the now deprecated LINQ to do this, so the code might look a little odd (LINQ looks like backwards SQL). ....... Else 'the user should see just their set of sites 'derive the allowed sites by looking up the site-codes/site-names for those allowed 'by the user in the junction table Dim mySites = From allsites In context.lookups Join perms In context.Permissions On perms.SIMSDatabaseCode Equals allsites.AdminSiteCode Where (perms.userID = userID And allsites.SIMSFileServerPath.ToString.Length > 0) Select Code = allsites.AdminSiteCode.ToUpper.Trim, Full = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(allsites.SiteFullName.Trim) 'use Title Case to properly capitalise the words 'bind the drop-down list to the result (2D array) SIMSDropDown.DataSource = mySites.ToArray() End If 'define the display and value members for the combo box SIMSDropDown.DisplayMember = "Full" SIMSDropDown.ValueMember = "Code"

I'm not too clued up on Access.... but..... I often use junction tables to do similar things to this. It might seem a horrible technique, but it's quite a logically efficient way of storing an indeterminate number of associated items (many to many). A junction table might look like this: Building | Room Main | A12 Main | B24 New | C12 Main | A8 New | B2 You can make a view selecting all the rooms where the Building = Main, etc. Bind your drop-down value to the result of the query against the junction table. e.g. select room from room_table where building = 'main' would give you a set of rooms for the 'main' building. Bind these to your drop-down. http://megocode3.wordpress.com/2008/01/04/understanding-a-sql-junction-table/

How bad is a '1'? It can't be dangerously bad, Shirly, or they'd close it down.....?

Your governers might be confusing 'cloud' with 'hosted'. We've got a centralised hosted solution, we've got quite a large set-up based on VMWare. About 100 SIMS databases are hosted on one virtual SQL server. Another virtual server is configured as a warm standby, kept up to date using log shipping routines. All the databases can be failed-over to the standby server in under 5 minutes. There's an enormous initial cost, but a greatly reduced support burden and far fewer items of infrastructure to look after. Access to the database is over WAN (private) networks. For cloud systems, this entails moving your server operating systems and your databases to another providers infrastructure. You'd get a console log-in, just as if you had your own virtual machines, but physically, these machines would be running on hardware at your cloud provider's site(s), rather than your own. This way, you won't need server hardware, UPS systems, backup mechanisms, etc, as in theory these would be provided by your cloud host. Access is encrypted over public internet connections. This is very unlikely to be successful for traditional client/server applications like SIMS. Unless SIMS is re-written as a cloud application, we are very unlikely to see SIMS as a true cloud application. However, Microsoft are keen for customers to adopt their Azure cloud offering, so there are tools for transforming apps for the cloud. This remains in the application developers' court. http://www.visualwebgui.com/Technology/WhitePapers/tabid/528/articleType/ArticleView/articleId/919/Transformation-of-ClientServer-application-to-Windows-Azure-Cloud.aspx There are cloud MIS systems available already, but as pointed out in earlier posts, there would no doubt be a 'significant' migration overhead.

As Vik says, if you're working at this level on your server, you should be an 'sa' user. If you have dual mode logins, log in as 'sa' and give your Windows user 'sa' privileges.

I'm using a Motorola Defy Mini, bought as an unlocked phone from Adsa for £79. It's a nice little phone. The battery life is very good (for a smart phone) It's got a small internal memory, which means you can't install tons of apps, but I only run with a basic suite of apps so that's OK with me. Power users should look elsewhere. http://direct.asda.com/Motorola-Defy-Mini-Mobile-Phone/008720853,default,pd.html

Some minimalist wallpapers. And very nice they are, too. http://simpledesktops.com/browse/ Edit: Found that DaveP posted this link many years ago, but I'll leave it as many would not have seen this.

Me too. PCONSOLE, anybody? Or is that too far back? Our last server to go was a NW 3.14 with 8 Meg of memory - 8 MEG, not GIG, running happily for years without being rebooted or maintained. I know this because we forgot about it. It was in a cupboard, and we forgot to run Novell's year 2000 patch on it. We 'progressed' to NT server, which needed daily reboots. Those were the days.

A treasure trove of famous synth sounds, samples and loops. Be sure to download #2 ('Processing') and set this through group policy as minimise and maximise sounds for all computers in your organisation. Then again, maybe you shouldn't. Famous Sounds

It's a good question; there are other plans on the Instrucables site which detail elaborate mechanisms with arms and suspension. We can see from the video results, though, that a basic handheld is quite adequate for most uses. Look at the way the guy violently moves the camera in front of the full mirror. Even this movement is smooth.

A few worrying '1's nearby. Luckily my favourite Indian is a '4' so we're on for Saturday.... The sandwich place that used to deliver to my old works got a '1'. Urgh.

That's not our experience at all. It runs like a dream on a well-planned system. Furthermore, VMWare makes efficiency savings if you have identical guest OSes/server apps as the hosts make use of shared memory (physical page sharing). One proviso - I'd build it from scratch, then backup/restore the databases. I wouldn't attempt to use a P2V utility, no matter how tempting. Furthermore, you'll have the old system intact in case things go south. Here's a useful 'best practices' guide about SQL on VMWare. http://www.vmware.com/files/pdf/sql_server_virt_bp.pdf Also, this should be compulsory reading for any SQL bod. Pay attention to the sections headed "Poor Performance By Design" and "The Biggest Mistakes". You can ignore the advice and take the defaults, but don't be surprised when it doesn't perform well. http://www.scribd.com/doc/28721265/Poor-Disk-Performance-Time-Outs-Database-and-the-SQL-Server-Error-Log And for the $PROPERTY of $DEITY, size your database files properly. Don't rely on auto-grow - its function is to prevent the server from crashing, it's not a management tool.

I'm sure dehumidifier crystals are a placebo. I took some out of a bag to see what would happen if I put them in a dish of water. Nothing happened. They remained little solid balls of plastic. I suspect the paper bag had more absorbent powers than the crystals.

You can shape your own with PVC tubing. 1. First fill the tube with sand. 2. Then put it in the oven until the plastic softens. 3. (Wearing oven gloves) bend the tube to shape. The sand prevents the tube from creasing. 4. $$$PROFIT$$$. (I disclaim any responsibility for sandy ovens)

Any plumbing centre will sell these bits. As for the tripod top, you could make one using 1/4" engineering bolt (I think these are the same standard camera-mount thread) or butcher a cheapo pound shop mini tripod to fit the frame. Fill your boots here: http://www.tlc-direct.co.uk/Main_Index/Conduit_Steel_Index/index.html

I've used AviDemux (on Linux) but it's for Windows too. Avidemux - Main Page If that's no good, there's a list of goodies here. Maybe one of these will do. http://en.wikipedia.org/wiki/List_of_video_editing_software

This is very impressive. This keeps the camera steady by means of a universal jointed handle and a counterbalance slung underneath the camera. To see the effect FF to 3:20.

Time for some ridiculous camping advice... This is my van last year at Newgale, west Wales. Reverse a Kangoo into an awning and hey presto... one motorhome. It's quite 'cosy', but it works. I bought a nice bell tent last year, really heavy cotton. Can't find any photos, but it's really easy to put up and recommended. The weather's been so bad I only used it twice last year and haven't been anywhere this year. Anyway, some actual sensible advice. Camping beds are usually terrible, and those polycell mats are purgatory. I bought some (oddly named) 'carp beds' (watch for typos) used by fishermen. This is the actual bed I bought (though I had it for £79 last year). TF Gear Chill Out 3 Leg Bed - Fishing Bed Chairs Fishtec Seriously, I've slept in worse hotel beds. They're fantastically comfortable.

It's already made it onto the Streisand Effect wiki page! Scroll down to 'Examples'. Streisand effect - Wikipedia, the free encyclopedia

Lawrence Krauss, the 'Woody Allen' of cosmology, gives a superb talk talk on the current state of physics and the possible origins of the universe. If you have a spare hour, it's well worth the watch.

Yup, it's big for sure. My sense of scale fails at the third slide.

You could call your program as part of the rc3.d startup files. I prefer this. You can call it from rc.local, too. The Fedora Basics FAQ I'm on Ubuntu at the moment at home -the startup directories are different- but I use Centos at work (same as Fedora) so I can check tomorrow.

Anecdote time. I recently bought a Motorola Defy Mini (Asda is selling them unlocked for £79). It's not a brilliant phone, but it's perfectly adequate, and water 'resistant' too (though I won't deliberately test that claim). Since its last charge, I've used the GPS to track a 90 minute walk, used the music player for 4x30 min sessions (with headphones, not speaker), a spot of Youtube, auto-checking 3 email accounts every 30 minutes and I've made a few calls and taken a few photos. So far, it's been on battery for exactly 48 hours and still has 25% charge left. Not bad at all. Mind you, it has a smallish screen and fairly low power processor, but it's OK for my modest requirements of the phone. It has a power conserver tool built into the ROM which I've configured to switch off data between 11pm and 7am. I'm sure this helps significantly.

This looks the simplest way of doing it - of course you'll have to wait until they fix the web-site problem with webmin. Ignore my previous concern with the 'sarge' repo - this is a Debian release, but the consensus indicates that it's OK in this instance. Install webmin in Ubuntu 12.04 | Unixmen

Looking at Webmin - their site says: I strongly suspect that this is the reason why it didn't work. Try it again when their site is working! If I were you, I would download the .deb standalone package and install it using the dkpg tool. You'll probably need to install dependencies, but you'll have to try it and see. This site appears to show the process (and I suspect it may be where you found those lines for the sources.list file). If so, it sounds reasonable. Install secure Webmin 1.580 on Ubuntu 12.04 LTS Precise Pangolin « Bongo's Codeways