C
charleswoods via AccessMonster.com
Dear Experts!
I have an Access application that was built by a VB programmer. The main
structure of this has the front-end forms and queries built into seperate
Access .mdb's and the tables linked back to a separate database holding
nothing but tables. Until recently, our network allowed any networked client
to access any other client's storage drive directly. This enabled us to set
up our system with the data(tables) in a separate physical drive than the
front end. Several days ago, our security team removed this accessibility
from our corporate platform.
This change prevented anyone from using the application since the front-end
couldn't access the data tables. To resolve, I moved the data(tables) into
the same folder and re-linked the existing tables to the new location.
The problem is this: every time I select a certain schedule from a drop down
box I get the following error: Run-time error 70 permission denied.
When I debug, the error occurs in the following line:
Set dbCurr = CurrentDb()
I don't have any other instance of Access open. My research shows that this
is either a lock violation or a permission violation. However, I cannot find
any instance of this open or being edited. I am not a VB programmer so I am
flying blind here. This app worked without incident before the security
change but I don't know enough to narrow down the root cause.
Here is the first few lines of code:
Sub Form_Load()
Dim i As Integer
Dim lngCount As Long
Dim dbCurr As DAO.Database
Dim qdfCurr As DAO.QueryDef
Set dbCurr = CurrentDb()
Dim mxhours As Long
If IsNull(Me.PositionSel) = True Then Me.PositionSel = Me.PositionSel.
ItemData(0)
....
Any advice is greatly appreciated!
Thanks
BlindHog
I have an Access application that was built by a VB programmer. The main
structure of this has the front-end forms and queries built into seperate
Access .mdb's and the tables linked back to a separate database holding
nothing but tables. Until recently, our network allowed any networked client
to access any other client's storage drive directly. This enabled us to set
up our system with the data(tables) in a separate physical drive than the
front end. Several days ago, our security team removed this accessibility
from our corporate platform.
This change prevented anyone from using the application since the front-end
couldn't access the data tables. To resolve, I moved the data(tables) into
the same folder and re-linked the existing tables to the new location.
The problem is this: every time I select a certain schedule from a drop down
box I get the following error: Run-time error 70 permission denied.
When I debug, the error occurs in the following line:
Set dbCurr = CurrentDb()
I don't have any other instance of Access open. My research shows that this
is either a lock violation or a permission violation. However, I cannot find
any instance of this open or being edited. I am not a VB programmer so I am
flying blind here. This app worked without incident before the security
change but I don't know enough to narrow down the root cause.
Here is the first few lines of code:
Sub Form_Load()
Dim i As Integer
Dim lngCount As Long
Dim dbCurr As DAO.Database
Dim qdfCurr As DAO.QueryDef
Set dbCurr = CurrentDb()
Dim mxhours As Long
If IsNull(Me.PositionSel) = True Then Me.PositionSel = Me.PositionSel.
ItemData(0)
....
Any advice is greatly appreciated!
Thanks
BlindHog