Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

System.mda performance impact

Posted on 1998-06-23
2
Medium Priority
?
241 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

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.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

610 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