Microsoft Access 2010 Tutorials
Multi-user Access Applications / Multi-User Application Basics
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Microsoft Access 2010 / Multi-user Access Applications / Multi-User Application Basics)
In this video I want to address the idea that you're always going to run into, probably ninety percent of the time, when you work with Access, and that is you build this cool little database application functionality, and other people see it, and they're like, hey man, I want to connect to that too. And understand, that when you to start to use Access as a multiple user application database, there's going to be some issues OK? Now this is normal, and natural, but let's first of all, talk about the bottom line foundation issue with Access is, it was designed by Microsoft to be used to by individual users, or very small business's. It was never intended to have a lot of users connecting to it simultaneously, running all kind of queries, doing all kind of actions, it just simply was not designed for that. Now, can you do that? Yes and can you find some information out there to help you configure Access to be a little more conducive to that kind of environment? Yes you certainly can. Now I'm going to be just a little sarcastic here, you have two choices when you're, find yourself in a situation of using Access as a multiple user application. The first is to read, test, implement, read some more, test some more, implement, just keep doing this over and over and over. There's a lot of situations, a lot of issues, some people use it as a multi-user application, and love it. Other people, you mention it, and they start flinging furniture around the room, and threatening people alright? There's a lot of information out there, you can chase it down. Now, the second option is, when you start to think about using Access as a multi-user application, just simply prepare and submit your two week notice alright? So, there's a wide variety of possibilities here, I just want you to understand, Access is really divided into two parts. The part that we open up when we double click on Access 2010, and we open up Access, that is really kind of the client side of it. And it's somewhat complex here, and I don't want to go too deep in this video with this, but we can split Access and pull those client functionalities onto our machine, and then we can put the actual database tables, and where the data actually lives, in a separate file, and put it on a server somewhere. This makes Access much more useful as a multi user application, and we'll talk about it a little bit more later. But again, keep in mind, you're using something that it really wasn't designed for. Can you pull a big boat to the lake, using a Honda Civic? Maybe, OK? You don't want to do it very often, and you don't want to count on that, and that's kind of the same thing with Access. Now notice, as you increase the number of clients on an Access application, you increase complexity, and you decrease efficiency. That's just all there is to it. So keep that in mind. Then you're going to have record locking issues, the more users you have, the more conflicts you're going to get into. Now you can work with these a little bit, and if you go to the Options Settings, and then go into Client Settings, inside there on the Backstage View in Access, you can kind of start to play with some of these things. Now let me show you that. If I go out into Access, and I go to the File Tab, and I come down here to Options, well if I go to Client Settings, and scroll down, notice, I can start to play with Advanced Features right here alright? And notice I can set some record locking issues, refresh intervals, I won't go through all of these, you can go out and read about this stuff in the help file, you can find all kind of technical information on the Internet, but just understand, you're wandering into some potentially deep and murky water when you start trying to use Access, as a multi-user application, OK? Can it be done? Yes. Just don't go too far with it, and don't make too many promises. The general rule is don't take Access past about ten to fifteen simultaneous users OK? So anyway, a little bit of rambling here, but I just kind of wanted to warn you and tip you off as to the challenges and limited opportunities with using Access as a multi-user application.
Tutorial Information
| Course: | Microsoft Access 2010 |
| Author: | Mark Long |
| SKU: | 34224 |
| ISBN: | 1-936334-91-7 |
| Release Date: | 2011-05-12 |
| Duration: | 9 hrs / 121 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
