R
Russ
I'm using SQL 2000 and an Access adp application. I create a table in a SQL
stored procedure. I then use the table as the record source for a form in
Access. This works fine in Access 2000, 2002, 2003 but Access 2007 can not
find the table ONLY when the user of the application is NOT the SQL 2000
database owner! I have tried using the Application.RefreshDatabaseWindow
within the Access 2007 VBA code but it will not work. Why is this only a
problem with Access 2007? I'm thinking there is some level of security in
Access 2007 preventing the non-SQL 2000 database owner (dbo) from refreshing
the database window.
The below code shows the command click event. Again this is only a problem
in Access 2007. With many users within our Agency upgrading to Office 2007
I'm going to have some re-design work to do if I cannot find a solution.
Private Sub cmdRefCand_Click()
DoCmd.OpenForm "frmDataRetrievalInvertOutputMetricSummary"
With Forms!frmDataRetrievalInvertOutputMetricSummary
.RecordSource = GlobalTemptblInvertReferenceSamplesHoldSummary
.txtSelectedPTV = Me.txtSelectedPTV
End With
End Sub
stored procedure. I then use the table as the record source for a form in
Access. This works fine in Access 2000, 2002, 2003 but Access 2007 can not
find the table ONLY when the user of the application is NOT the SQL 2000
database owner! I have tried using the Application.RefreshDatabaseWindow
within the Access 2007 VBA code but it will not work. Why is this only a
problem with Access 2007? I'm thinking there is some level of security in
Access 2007 preventing the non-SQL 2000 database owner (dbo) from refreshing
the database window.
The below code shows the command click event. Again this is only a problem
in Access 2007. With many users within our Agency upgrading to Office 2007
I'm going to have some re-design work to do if I cannot find a solution.
Private Sub cmdRefCand_Click()
DoCmd.OpenForm "frmDataRetrievalInvertOutputMetricSummary"
With Forms!frmDataRetrievalInvertOutputMetricSummary
.RecordSource = GlobalTemptblInvertReferenceSamplesHoldSummary
.txtSelectedPTV = Me.txtSelectedPTV
End With
End Sub