C
C.B.
Recently I converted a database from Access 97 to Access
2000 and re-secured it with a new work group. I am not
sure what version of Access the database was originally
designed in, but it is pretty old. The conversion process
seemed to have gone smoothly. I have tested the
functionality of the database and compared reports and
exports with the Access 97 exports and everything appears
to function correctly.
The problem arose when I delivered the database to a
different PC. One of the forms linked from the
switchboard has lost all of its functionality. This form
uses VB code to perform output routines, manipulate/query
data tables and navigate back to the switchboard.
Controls on the form are updated through the use of the
requery command. All command buttons (which are trigged
by the click event) on this particular form fail to
execute the code. No errors are flagged.
*** The curious thing is that if I switch to design view
and then back to form view all the functionality becomes
active. ***
Also note that I only saw this problem on certain PCs.
The only difference between access versions appears to be
the build number.
The PC that behaves correctly has the following
characteristics....
MS Access
Version - 9.0.6926 (SP3)
Build 3822
ADO Ver. 2.5
VBA 6.00 (version 3967)
Reference - VBA, Access, stdole,DAO,VBIDE
Jet Version 4.0
The database fails to function on a PC with the following
characteristics....
MS Access
Version - 9.0.6926 (SP3)
Build 6620
ADO Ver. 2.5
VBA 6.00 (version 3967)
Reference - VBA, Access, stdole,DAO,VBIDE
Jet Version 4.0
I am not really sure what to look at next. My guess would
be that it is related to how the VB code is compiled.
This problem could be linked to an out-of-date reference
library, but I am not sure. Any information would be
greatly appreciated. Please let me know if you have
questions. Thanks!
2000 and re-secured it with a new work group. I am not
sure what version of Access the database was originally
designed in, but it is pretty old. The conversion process
seemed to have gone smoothly. I have tested the
functionality of the database and compared reports and
exports with the Access 97 exports and everything appears
to function correctly.
The problem arose when I delivered the database to a
different PC. One of the forms linked from the
switchboard has lost all of its functionality. This form
uses VB code to perform output routines, manipulate/query
data tables and navigate back to the switchboard.
Controls on the form are updated through the use of the
requery command. All command buttons (which are trigged
by the click event) on this particular form fail to
execute the code. No errors are flagged.
*** The curious thing is that if I switch to design view
and then back to form view all the functionality becomes
active. ***
Also note that I only saw this problem on certain PCs.
The only difference between access versions appears to be
the build number.
The PC that behaves correctly has the following
characteristics....
MS Access
Version - 9.0.6926 (SP3)
Build 3822
ADO Ver. 2.5
VBA 6.00 (version 3967)
Reference - VBA, Access, stdole,DAO,VBIDE
Jet Version 4.0
The database fails to function on a PC with the following
characteristics....
MS Access
Version - 9.0.6926 (SP3)
Build 6620
ADO Ver. 2.5
VBA 6.00 (version 3967)
Reference - VBA, Access, stdole,DAO,VBIDE
Jet Version 4.0
I am not really sure what to look at next. My guess would
be that it is related to how the VB code is compiled.
This problem could be linked to an out-of-date reference
library, but I am not sure. Any information would be
greatly appreciated. Please let me know if you have
questions. Thanks!