P
Peter Moffatt
I have an Access97 application which has been running under Windows 98
for several years. Recently the application was transferred to a new PC
running XP. Following this some puzzling error messages have occurred,
in the general form:
"...can't load the '005' format. The setting for this format in the
registry is incorrect. You will not be able to save output data to
a file in this format until you correct the setting in the registry."
The first time this occurred was immediately on opening the application,
which continued as normal when the message box was closed. The '005'
appeared to come from one of the fields in a linked table called
'Settings', which contains 2005 as the current year. If this setting
was changed, say to 2004, "..the '004' format.." appeared in the
message. Similar messages occurred at other times, in at least some
cases with the 'format' description taken from part of the contents of
a field in the Settings table. The startup message was not consistent,
and often did not appear if the application was re-started from the db
window while access remained loaded. I wondered if the Access table
being called 'Settings' might be significant.
Another new startup oddity was that the form design toolbar appeared
spontaneously on my start screen, which normally has the standard Menu
Bar disabled and a custom menu displayed.
A similar but rather more logical 'format' error occurred when the
application outputs data from an Access table to an Excel worksheet,
using
DoCmd.OutputTo acOutputTable, <tablename>, acFormatXLS,
<worksheetname>
The error message was RTE 2282, and to the effect that
"The formats that enable you to output data in Excel, Rich text,
MS-DOS text or HTML format are missing. You will not be able
to output data to files in these formats until you correct the
settings in the registry". (Wording probably not exact).
I found what I took to be the registry entries referred to (?) at
HK_LOCAL MACHINE\ software\Microsoft\Jet\3.5\ISAM formats\Excel8
and it showed Output Format as "Microsoft Excel (*.xls)", which is the
value of the Access constant acFormatXLS used in the DoCmd method. I
have also discovered numerous registry entries by searching for '.xls',
but have no idea which if any of these are relevant or if others are in
fact missing. I suspect not, as the error eventually stopped occurring,
to be replaced by a "subscript out of range" error in an Excel macro
which has been working for years.
If anyone can shed any light on why these messages occur, and whether or
not they might be related to the change to Windows XP, I would be most
grateful.
Thanks,
Peter Moffatt.
for several years. Recently the application was transferred to a new PC
running XP. Following this some puzzling error messages have occurred,
in the general form:
"...can't load the '005' format. The setting for this format in the
registry is incorrect. You will not be able to save output data to
a file in this format until you correct the setting in the registry."
The first time this occurred was immediately on opening the application,
which continued as normal when the message box was closed. The '005'
appeared to come from one of the fields in a linked table called
'Settings', which contains 2005 as the current year. If this setting
was changed, say to 2004, "..the '004' format.." appeared in the
message. Similar messages occurred at other times, in at least some
cases with the 'format' description taken from part of the contents of
a field in the Settings table. The startup message was not consistent,
and often did not appear if the application was re-started from the db
window while access remained loaded. I wondered if the Access table
being called 'Settings' might be significant.
Another new startup oddity was that the form design toolbar appeared
spontaneously on my start screen, which normally has the standard Menu
Bar disabled and a custom menu displayed.
A similar but rather more logical 'format' error occurred when the
application outputs data from an Access table to an Excel worksheet,
using
DoCmd.OutputTo acOutputTable, <tablename>, acFormatXLS,
<worksheetname>
The error message was RTE 2282, and to the effect that
"The formats that enable you to output data in Excel, Rich text,
MS-DOS text or HTML format are missing. You will not be able
to output data to files in these formats until you correct the
settings in the registry". (Wording probably not exact).
I found what I took to be the registry entries referred to (?) at
HK_LOCAL MACHINE\ software\Microsoft\Jet\3.5\ISAM formats\Excel8
and it showed Output Format as "Microsoft Excel (*.xls)", which is the
value of the Access constant acFormatXLS used in the DoCmd method. I
have also discovered numerous registry entries by searching for '.xls',
but have no idea which if any of these are relevant or if others are in
fact missing. I suspect not, as the error eventually stopped occurring,
to be replaced by a "subscript out of range" error in an Excel macro
which has been working for years.
If anyone can shed any light on why these messages occur, and whether or
not they might be related to the change to Windows XP, I would be most
grateful.
Thanks,
Peter Moffatt.