Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 216
  • Last Modified:

Opening a .mdb over a Windows 2000 network

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.
1 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


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
Nirmal SharmaSolution ArchitectCommented:
>>>\\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?


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now