M
mj
I'm a beginner-level Access programmer now responsible for maintaining a
series of databases created five years ago. We operate in an unstructured
multi-user networked environment, running Access 2003 SP3 on Windows XP Pro
SP2. Access is installed on each computer, while the databases are located
on a network drive. For the last several months, we have had a problem with
duplicate databases (*.db?) being left behind after closing the program. I
discovered the Post-SP3 hot fix that looked like it would address this
problem (http://support.microsoft.com/kb/945674), and installed it.
After installation, we still get occasional temp db files left behind, and
now we have another problem appear: When we click a button on a form to run a
macro that creates an htm file from a query, we get a fatal error --
"Microsoft Office Access has encountered a problem and needs to close." An
htm file is created, however it is populated with a table containing only one
record instead of the typical dozens of records.
The button function:
Private Sub btnUpdateWebpage_Click()
On Error GoTo Err_btnUpdateWebpage_Click
Dim stDocName As String
stDocName = "UpdateLeadershipWebpages"
DoCmd.RunMacro stDocName
MsgBox ("Webpages Updated")
Exit_btnUpdateWebpage_Click:
Exit Sub
Err_btnUpdateWebpage_Click:
MsgBox Err.Description
Resume Exit_btnUpdateWebpage_Click
End Sub
In the macro, WarningsOn is No, and then a query is opened, and output is
sent to four different htm files, using different sorts on the query. The
macro crashes after attempting to create the first htm.
This macro fault only occurs on computers with the hot fix installed - it
does not happen on a computer where we did not install the hot fix.
I suspect our database might have design/corruption issues, although we
don't notice any flaws in the data (we can always open the databases and
tables, we don't see any missing or bad data fields or records, the changes
we make always seem to stick, ...). Could there be a fault that pre-hot fix
Access ignores/accepts, but post-hot fix Access trips on?
I appreciate any help you can offer. Please let me know if you need more
information. Thanks!
series of databases created five years ago. We operate in an unstructured
multi-user networked environment, running Access 2003 SP3 on Windows XP Pro
SP2. Access is installed on each computer, while the databases are located
on a network drive. For the last several months, we have had a problem with
duplicate databases (*.db?) being left behind after closing the program. I
discovered the Post-SP3 hot fix that looked like it would address this
problem (http://support.microsoft.com/kb/945674), and installed it.
After installation, we still get occasional temp db files left behind, and
now we have another problem appear: When we click a button on a form to run a
macro that creates an htm file from a query, we get a fatal error --
"Microsoft Office Access has encountered a problem and needs to close." An
htm file is created, however it is populated with a table containing only one
record instead of the typical dozens of records.
The button function:
Private Sub btnUpdateWebpage_Click()
On Error GoTo Err_btnUpdateWebpage_Click
Dim stDocName As String
stDocName = "UpdateLeadershipWebpages"
DoCmd.RunMacro stDocName
MsgBox ("Webpages Updated")
Exit_btnUpdateWebpage_Click:
Exit Sub
Err_btnUpdateWebpage_Click:
MsgBox Err.Description
Resume Exit_btnUpdateWebpage_Click
End Sub
In the macro, WarningsOn is No, and then a query is opened, and output is
sent to four different htm files, using different sorts on the query. The
macro crashes after attempting to create the first htm.
This macro fault only occurs on computers with the hot fix installed - it
does not happen on a computer where we did not install the hot fix.
I suspect our database might have design/corruption issues, although we
don't notice any flaws in the data (we can always open the databases and
tables, we don't see any missing or bad data fields or records, the changes
we make always seem to stick, ...). Could there be a fault that pre-hot fix
Access ignores/accepts, but post-hot fix Access trips on?
I appreciate any help you can offer. Please let me know if you need more
information. Thanks!