Connect with us

Tech

Microsoft Access Database: How To Deal And Dispense The Myth That Access Can Not Handle Multi-Users

Published

on

If I had a Pound (or dollar) every time I heard that Microsoft Access is not good enough when dealing with multiple ‘concurrent’ users and that performance degradation and locking issues are the main symptoms when trying to share an Access database; I’d be able to retire and give more of my time back into society which really needs my help!

In 2004, I was asked to build an Access Database that would handle over 30 users to utilise and place orders, processing them and have other members fulfil the goods in a manufacturing module, First of all, I had to establish not how many users but how many concurrent users would be expected to use the Microsoft Access database application which the client confirmed 25-30 users would were needed to hit the same database at the same time.

There are a lot of opinions whether Microsoft Access can actually handle multiple users and large volumes of data and for sure there are pros and cons (which is not going to be covered here), There’s a saying in any field of expertise “Put 7 experts in a room and ask them for an opinion and you will get 21 different answers.

My view is simple; try Microsoft Access first and then at least if you need to move to a bigger application then you can move on knowing that at least you gave it a go!

So in order to help you along, there are 5 reasons to deal and dispense with the myth why Access can be used in a multi-user environment.

  1. The most popular action to take is to split the Access database into two parts. Have all the tables in one database and the remaining objects in another. Make sure you store the ‘Tables’ database (commonly known as BE- Back End) on the server or shared network folder with the other database (commonly known as FE – Front End) on each user’s desktop which has a link to the BE database.
  2. When designing your tables, learn to set indexing to the commonly used fields and not just set the ‘Primary’ key in a table. The other type of key often overlooked is known as the ‘Foreign’ key. This all helps with performance and speeds up the queries in Microsoft Access.
  3. Loading forms can be memory intensive and to help the performance and avoid locking consider opening a form as ‘unbound’ to the data source. You can then populate the data via a macro or VBA code to handle the data when required.
  4. Using forms and reports is an overhead that can be easily controlled (and is one reason why they are stored on the desktop). Keep the number of controls to a minimum which means fewer tab pages and unnecessary text-boxes to hold calculations and other hidden values. There are better ways to handle this but will require some simple VBA code knowledge.
  5. Use ‘local‘ temporary tables to handle offline processing which can then be sent to the BE database as and when required helping to keep traffic as free as possible.

There are other techniques that can be added to help handle multiple ‘concurrent‘ users but first had experience says you can use a Microsoft Access database across a network as a simulated Client/Server database application.

google news

Tech

Elite League of Legends Teleport Tricks to Destroy Your Friends

Published

on

By

Every day, thousands of gamers log onto League of Legends to play Riot Games’ free DOTA-style video game, unfortunately most of them get crushed by the elite few that know all the tricks of the trade. The most popular tricks often involve one of the lesser used summoner spells in public games; the incredibly useful but oft-ignored teleport spell, and while these tricks can take weeks to master, it only takes a few moments to read on and learn them.

1. Fiddlesticks’ Surprise — If there is one sound that strikes fear into the heart of every experienced League of Legends player, it’s the horrifying “Caw! Caw! Caw!” of Fiddlestick’s monstrous ultimate, which is nothing less than an area of effect spell of doom for everyone caught in its wake. The problem with this spell, of course, is its two-second channel time that requires you to be smart about when you’re ready to attack. Surprisingly, few players realize the power of this ultimate when combined with the utility of the teleport summoner spell.

An awesome way to get the drop on your opponents with Fiddlesticks, is to lay a ward down in the farthest bushes on the top or bottom lane of the map. When done correctly, you can teleport in behind your opponent and out of sight, waiting for the right time to launch from the bushes and strike. This is particularly effective if for some reason you are playing Fiddlesticks in the lane, as you can recall base before quickly teleport behind them to create mass confusion.

2. Nunu’s Trap — Nunu is well-known in League of Legends to have one of the strongest ultimates in the game, capable of swallowing entire teams in its large radius and exploding them into a million bits. Unfortunately, this is perhaps the most difficult ultimate to land in the game as it has a long stationary channel that is easily interrupted and even more easily stepped out of…. that is, of course, unless you have the teleport summoner spell.

With the teleport spell at your disposal, Nunu can quickly become a frightful player for the opposing team. Try sneaking a ward right into the middle of the middle lane to teleport to later, and wait until your opponent’s solo mid steps by it. When he does, teleport in and quickly ice-blast him for the slow effect, pop your ultimate and watch as he explodes with the help of a teammate already in that lane. This is an awesome technique because you will actually give yourself an additional second or so for your ultimate to go unnoticed, as your opponent will be extremely confused as to how you appeared next to him out of the middle of nowhere.

This is also an effective technique at grouping hot-spots, like Baron, Dragon, or a short distance in front of your middle tower. Placing a ward a bit in front of your middle tower is particularly rewarding, as once you teleport in and cast your ultimate while your opponents are attacking your tower, they will be pinched in and be forced to move into the tower where all your teammates await, or back toward you for an icy surprise of ultimate death.

google news
Continue Reading

Tech

How to Play Spoons Card Game

Published

on

By

How would you like to play a game that could be enjoyed by the entire family regardless of age? Sounds pretty fun, right? Well, we’re going to teach you about just that game. It’s called spoons, and it’s one of the more popular card games. It’s really simple to play, and it’s really enjoyable! So just follow these simple steps.

What you’re going to need:

  1. Spoons ( You need one less spoon than there are players. So let’s say that there are 5 players, you need six spoons )
  2. Deck ( Full Deck of Cards )

Game Set Up

To set up the game, you’re going to need to count the number of players. Let’s say that there are six players in your group. You’re going to need six suits of cards. You don’t need to use the whole deck.

Now, at this point, you’re going to need to put the spoons in the center of the table and pass out an equal number of cards to each player. Then you’re ready to go!

Game Play

Once each player has a hand of cards, it’s time to get started. The object of the game is to get a suit of hands in your card, so what you’re going to do is select one card from your hand and pass it to the player on the left. At this point, the player on the left, the one receiving the card, has the option to take that card into his hand, or he can pick a card from his hand and pass it to the player on his left. This continues until one player has an entire suit of cards in his hand.

Once that happens, his goal is to sneakily grab a spoon from the center of the table. If other people find out he has an entire suit, they could inadvertently make him the loser, so don’t let that happen. Once you’ve grabbed the spoon you reveal your hand to the other players.

They then have to hastily grab their own spoons. The player who is left without a spoon is then declared the loser and removed from the game. The game play continues until there are only two players in the group. At which time, they are both declared the winner.

Get Your Game On!

As you can tell, spoons is a real simple game, and it is perfect for those family game nights. So we recommend you give it a try! We guarantee you won’t be disappointed.

google news
Continue Reading

Tech

Dog Training Academy – How to Create Obedience in Your Dog

Published

on

By

Training a dog can be a frustrating act but not anymore with the Dog Training Academy e-course. Dogs tend to be unruly at times with excess of barking and whining along with aggressive actions towards visitors. It is high time to start training your dog using well established and proven methods when you find him reacting in a non responsive manner to your commands.

Lack of training can lead to behavioural problems in your dog and this can turn them into a disobedient pet. An unruly pet can end up tearing furniture or behaving in an uncontrollable manner. It is hence necessary that you take the right measures to control behavioural problems and to train your dog. This is where Dog Training Academy can help you get the perfect pet by bringing in obedience in your dog. The training course is a 7 day series that consolidates tips and tricks on training your dog on obedience matters.

Training a dog is not an easy task, but the job now becomes simple for you now with this free training e-course. The methods of training and the skills of the owner and pet normally determines the time taken to train a dog, but this training e-course can resolve all your problems in just about 7 days. They provide you with many widely practiced professional methods of obedience training to bring in fast and effective behavioural changes.

Basic bonding and effective communication is required between you and your dog before you can start training on obedience. This kind of essentials that needs to be obtained before the dog can respond to your basic commands and orders are detailed in the Dog Training Academy course.

There are many ways of training your dog other than the e-course methodology. One such way of obedience training your dog is by taking him to a training school. Such schools provide professional help offered by expert trainers who can handle any kind of dogs. But is it necessary to check whether such schools are recognized ones before your enrol your dog. Such kind of schools also charge a hefty amount for a complete training spanning around 3-4 weeks time as compared to the free course.

A proven training plan and a step-by-step guide of the plan can make you feel the difference in your dog’s behavior in just a week time. The training plan can bring in more obedience and security in your dog at the end of the course. Enrol for the Dog Training Academy course and you no longer need to worry about torn furniture or garbage in your living room.

google news
Continue Reading

Trending