?
Solved

System.mda performance impact

Posted on 1998-06-23
2
Medium Priority
?
239 Views
Last Modified: 2013-12-05
I have a database used by 4-12 people at a time. The system mda file contains all possible users - around 150. Performance is KEY in this database.

Previously I had the system.mda located on the network with the data. The icon on everyone's machine pointed to the network system.mda. This worked GREAT. Maintenance for me was a breeze because any forgotten passwords or requests for new users could be handled immediately.

However - I got the 'great' idea to offload the system.mda to the users machine to save on performance. I can tell that the login screen displays faster - but don't know how much performance gain I'm getting now. I do know that maintenance is turning into a nightmare. Users can use different PCs and now - if they change their password - the change is only reflected on the single machine. Setting up new users is no longer a simple single step process.

My question - What am I gaining besides initial load time savings by putting the system.mda (mdw) on the local machine. Specifically - how often is the system.mda accessed? Is it accessed once at log in - or for every table retrieval?

All comment are welcome - but please don't post an answer unless you KNOW how the system mda/mdw is used.

Thanks!
CEKMAN
0
Comment
Question by:cekman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 4

Accepted Solution

by:
tomook earned 210 total points
ID: 1975687
As you suspect, the main thing you are saving is time to bring up the logon screen. By having the SYSTEM.MDW locally, you will also save a few milliseconds between when you enter your user name & password and the UI comes up. In my book, this is not enough to trade for simplified administration.

To clarify what is happening, here is the sequence of events when Access starts.
1. Access locates the SYSTEM.MDW/MDA and tries to log in as "Admin" with no password. If it succeeds, skip to step 4.
2. The "Log On" form comes up and asks for a user name and password.
3. Access looks up the user name in the table MSysAccount in the System.MDW (I don't know if SYSTEM.MDA used the same table name). If found, it looks up the password and compares it with the one supplied. If the user name/pw cannot be validated, go back to step 2.
4. The user's SID is read and cached somewhere in Jet.
5. The user's groups are found and the SID's for each group is also cached.
6. The UI starts.

After step 5, the SYSTEM.MDW is not really used, unless you change a password or some such. The SID is the "magic" string <=20 characters long you supplied when you created a user or group. All the permission information is contained in the MDB, keyed by SID.
0
 
LVL 4

Expert Comment

by:tomook
ID: 1975688
cekman:
Did this answer your question?
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question