Opening a .mdb over a Windows 2000 network

Posted on 2005-04-12
Last Modified: 2010-04-13
I am trying to open a database that resides on a network path. The network and all OS are Windows 2000. The path name of the database is:

\\linn_alc_drug1\common_dd\Access Database\Developmental Disabilities Network\CaseMgt.mdb

Public Sub DBConnect()
    Dim Path As String
    Dim Conn As New ADODB.Connection
    Dim Cmd As New ADODB.Command
    Dim RS As ADODB.Recordset
    frmLoad.lblLoad.Caption = "Opening Database..."
    Path = "\\linn_alc_drug1\common_dd\Access Database\Developmental Disabilities Network\CaseMgt.mdb"
    Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " & Path
End Sub

When I run the sub it states that the file is already open and can not be accessed. I know that the .mdb is not open. Any suggestions on what I should do.
Question by:wilsoada
    LVL 16

    Accepted Solution

    This often happens because the file you are trying to open is read-only. Either the RO flag is set on the file or the NTFS or share permissions are set to only allow that user read-only rights


    LVL 16

    Expert Comment

    Login to the server linn_alc_drug1. Right click My Computer and choose manage. Expand to System Tools > Shared Folders > Open files. Sort by open files and see what files are open.

    I've worked with a few of our db guys who had trouble opening a db saying it was opened. We went to the station/user where it was supposedly open and well it wasn't, but on the server it was listed as open. That and it's .ldb file
    LVL 35

    Expert Comment

    by:Nick Sui
    >>>\\linn_alc_drug1\common_dd\Access Database\Developmental Disabilities Network\CaseMgt.mdb

    Did you check any service which is stopping you from opening this database?


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
    Outlook Free & Paid Tools
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now