2003/2000 Strange thing

K

Kmagg

We have a database that was programmed by an ex-employee and unfortunately we
know enough about Access to be very dangerous. If we open said database
(which is switchboard controlled) in 2003 , the Report toobar (the one with
the export capability) appears when we run a report. If we open it in 2000,
the toolbar flashes then disappears. If we open it in Design mode in 2000,
it's back.

We really, really need help in getting this toolbar to stay in place. Would
anyone happen to have an idea how we can correct this?
 
A

Allen Browne

Presumably the report's toolbar property is set correctly (Other tab of
Properties box, in report design.)

You can probably rescue this by getting Access 2000 to recreate the database
for your.

1. Create a new (blank) database in Access 2000

2. Uncheck the Name AutoCorrect boxes under:
Tools | Options General
For an explanation of why, see:
http://allenbrowne.com/bug-03.html

3. Import everything:
File | Get External | Import
Be sure to click the Options button in the Import dialog, and check the box
for toolbars.

4. Close Access, and decompile by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

5. Compact the database:
Tools | Database Utilities | Compact.
 
K

Kmagg

Thanks for the reply Allen. I've also just found out that if we open the
database on another 2000 machine, it opens the toolbars correctly. So, now it
appears that everyone except the person who uses the database has the export
functionality. Do you think the Autocorrect fix is the thing to do since it
appears other 2000 users see the toolbar? Could the user have something set
 
A

Allen Browne

If the same database works on everyone else's machine, then it is more
likely that the bad machine is lacking a service pacth or permission or some
other factor.

Help | About will give you the office service pack number.

For the JET 4 service pack, locate msjet40.dll (typically in
windows\system32), right-click and choose Properties, and look on the
version tab. If you don't see the 8 in 4.0.8xxx.0, download SP8 for JET 4
from:
http://support.microsoft.com/gp/sp
 
Top