mdb on different server

Results 1 to 2 of 2

Thread: mdb on different server

  1. #1
    Join Date
    Dec 1969
    Posts
    264

    Default mdb on different server

    Hello,

    I'm using the following to connect:

    adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;User ID=;Password=; Data Source=\\servername\subfolder\subfolder\subfolder\ \database.mdb;

    I'm receiveing the following:

    Microsoft JET Database Engine error '80004005'
    The Microsoft Jet database engine cannot open the file '\\servername\subfolder\subfolder\subfolder\\datab ase.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

    I know for a fact it is not already open. I've changed rights to everyone/full just to test (no change).

    Wondering if anyone has any advice as to what I am doing wrong?

    Thanks,

    Randall

  2. #2
    Join Date
    Dec 1969
    Posts
    95,968

    Default

    Try opening it as a file, just to see if it works:
    Code:
    Set fso = Server.CreateObject("Scripting.FileSystemObject")
    Set text = fso.OpenTextFile("\\servername\subfolder\subfolder\subfolder\\database.mdb")
    text.close
    If that works, then it's possibly occurring when Jet tries to open it for read and write. If you can stand using it in read-only mode, you could change the connection to readonly before you open it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


More ASP Resources

Resources:
-- ASP Articles
-- ASP.NET Information
-- 4Guys ASP F.A.Q.
-- ASPFAQs.com
-- ASP Coding Tips
-- Related Web Technologies
-- User Tips!!
-- JavaScripts


Development Centers
-- HTML5 Development Center
-- Windows Mobile Development Center
-- Android Development Center
-- Cloud Development Project Center


Development Technology
Check out these sites for more articles, tutorials, FAQs, discussions, and code!
-- CodeGuru.com
-- VBForums.com
-- DevX.com
-- Developer.com
-- HTMLGoodies