Results 1 to 7 of 7
  1. #1
    azstyx is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    4

    What is system.mdb

    Hello,
    I am monitoring an ASP/IIS7.0 application that opens and updates a MS Access 2003 db. Process Monitor shows that JET tried to access the following file: system.mdb
    What is that file?
    Example Process Monitor records:


    "9:10:33.7886011 AM","w3wp.exe","4764","CreateFile","C:\Windows\Sys tem32\inetsrv\system.mdb","NAME NOT FOUND","Desired Access: Read Attributes, Disposition: Open, Options: Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, Impersonating: NT AUTHORITY\IUSR","NT AUTHORITY\NETWORK SERVICE"
    "9:10:33.7897286 AM","w3wp.exe","4764","CreateFile","C:\Windows\Sys tem32\inetsrv","SUCCESS","Desired Access: Read Data/List Directory, Synchronize, Disposition: Open, Options: Directory, Synchronous IO Non-Alert, Attributes: n/a, ShareMode: Read, Write, Delete, AllocationSize: n/a, Impersonating: NT AUTHORITY\IUSR, OpenResult: Opened","NT AUTHORITY\NETWORK SERVICE"
    "9:10:33.7898795 AM","w3wp.exe","4764","QueryDirectory","C:\Windows \System32\inetsrv\system.mdb","NO SUCH FILE","Filter: system.mdb","NT AUTHORITY\NETWORK SERVICE"

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    It's a database that someone created on your network, I have no idea what your code is choking or why, it may be that system.mdb was created to keep a log of what's happening within your ASP code.

    I take it your ASP code has started to fail when you attempt to run it? If so, find out where system.mdb is on your network and check it's permissions. If it can't be opened by the person running the ASP code or is read only and your database is trying to update a record you may be having some issues. I don't do a whole lot of ASP but without some example of what your code is trying to do it's a shot in the dark.

  3. #3
    azstyx is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    4
    The ASP code is working fine. I'm using COM/ADO calls to expose JET. This file system.mdb is seen being accessed by the IIS service w3wp.exe:
    C:\Windows\System32\inetsrv\system.mdb
    I was just curious why JET was looking for this file?

  4. #4
    azstyx is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    4
    BTW, I coded the ASP page using JScript:
    var objDB = Server.CreateObject("ADODB.Connection");
    var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + myDB + ";";
    objDB.Open(strConn); // open Access DB
    var objRs = Server.CreateObject("ADODB.Recordset"); //create RecordSet object
    objRs = objDB.Execute(SQL);

  5. #5
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    so your myDB variable isn't

    \\serverpath\system.mdb?

    I only use ASP in conjunction with a SQL table so I'm shooting in the dark here. Does the W3WP.exe program have an access back end and if so is it called system.mdb?

  6. #6
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    You sure that you aren't meaning System.mdw

  7. #7
    azstyx is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    4
    Hi, no its system.mdb; here is the Process Monitor log record showing JET trying to create this file:
    "9:10:33.7886011 AM","w3wp.exe","4764","CreateFile","C:\Windows\Sys tem32\inetsrv\system.mdb".
    The server is WIN2008 Standard, running IIS7.0 and Classic ASP/JScript.
    myDB is set to "D:\\tools\\prod6\\data\\ucomm.mdb".

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 04-12-2011, 10:14 AM
  2. Inventory System
    By Rawb in forum Database Design
    Replies: 8
    Last Post: 01-05-2011, 07:26 AM
  3. Ordering System
    By Gustavo in forum Access
    Replies: 1
    Last Post: 11-21-2010, 02:16 AM
  4. System.mdb or System.mdw?
    By cgriella in forum Access
    Replies: 1
    Last Post: 09-30-2008, 08:16 AM
  5. Basic Quoting System
    By Travstar in forum Access
    Replies: 2
    Last Post: 12-12-2005, 09:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums