Solved

System.mda performance impact

Posted on 1998-06-23
2
229 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
  • 2
2 Comments
 
LVL 4

Accepted Solution

by:
tomook earned 70 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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now