none
Microsoft.Jet.OLEDB.4.0 and remote database on webservice slow RRS feed

  • Question

  • Am in the process of transfering to a new server hosting our web services and in between times the Access database is on a remote network share. There is a delay of 1 second while the jet engine is trying to delete the .ldb file. Using the ProcMon application have found the delay is coming from the CreateFile function. Think it is because of this from http://msdn.microsoft.com/en-us/library/aa363858(VS.85).aspx

    Windows Server 2003 and Windows XP/2000:  A sharing violation occurs if an attempt is made to open a file or directory for deletion on a remote computer when the value of the dwDesiredAccess parameter is the DELETE access flag OR'ed with any other access flag, and the remote file or directory has not been opened with FILE_SHARE_DELETE. To avoid the sharing violation in this scenario, open the remote file or directory with the DELETE access right only, or call DeleteFile without first opening the file or directory for deletion.

    The 1 second delay disappears when the database is stored local on the server.

     

    Tuesday, October 5, 2010 8:55 AM

Answers

  • I'm not exactly sure what your question is. Performance is typically going to decrease when using a file based database system over the network, especially in multi-user systems involving Microsoft Access.

    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Proposed as answer by liurong luo Thursday, October 14, 2010 10:50 AM
    • Marked as answer by liurong luo Tuesday, October 19, 2010 3:20 AM
    Tuesday, October 5, 2010 1:00 PM