Avatar of vbnewbie08

asked on 

File Already in Use error

Program basics:  Application interacts with a Access DB stored on a mapped network drive.  I have set the permissions for ANYONE to be able read/write to the db at the db and folder level.  

Problem:  On any computer BUT mine (the dev workstation), the user selects an item from the flex grid and Form2 opens with details on the selected item.  It works fine the first time, once they close Form2 and try to select another item from the grid, they receive the error:
Run-time error '-2147467259 (80004005)':  Could not use "; file already in use.

Interesting note:  If I log onto another machine, install the App and try to run it UNDER MY LOGIN it still happens, just not on the dev machine.  And I did use Package & Deployment.

Any idea?
Dim path as String
intFile = FreeFile
Open "G:\Support\Applications\FixIT\databasepath.txt" For Input As intFile
path = Input(LOF(intFile), intFile)
    Set Connection1 = New ADODB.Connection
     Connection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & path & ";Jet OLEDB:Database Password=*******;"

Open in new window

Visual Basic ClassicMicrosoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon