97 to 2k conversion problem

  • Thread starter Thread starter disco
  • Start date Start date
D

disco

After conversion from 97 to 2k found that a few forms
would not work properly these forms use combo box to
access a record and you should be able to reuse this
repeatedly to access different records but the 2k version
will only let u do this once then close form and get back
in. Is it possible that somehow the VB code has gotten
changed in conversion or is the problem elsewhere and not
in the code?

Any ideas or comments would be appreciated!

Thanks
Disco
 
There is a rather huge difference in the compilation of VBA coding between
97 and 2k, so you may need to decompile then recompile the code in 2K. I
ran into similar situation with Excel's Userforms, when my code went from 97
to 2k, thus I had to go into the code and then recompile the code.
 
Exaclty how do i do that? I am somewhat familier w/ VB
but not sure how to do what u r suggesting.
 
To decompile an Access DB file, use the /decompile option on a command run
line such as:

goto Start, Run

Type "msaccess /decompile"

CRITICAL: After typing that in, be sure to press and hold down the "Shift"
key before you press the Enter key until AFTER access has fully openned. If
this is not followed through fully and even one form open that causes the
code to compile, this decompilation process has done no good.

Here's the 8 steps that's been suggested to do according to the book that I
have titled "Access 2002 Bible", by Michael R Irwin, and Cary N. Prague.
They mention 6 steps as they included the closing of the database as part of
the step before it. This is found on page 1314 & 1315.

1 Reboot your system as this cleans up your memory.

2 Create a NEW Access DB and import all object from the old Access DB file.

3 Close Access

4 Restart Access by using the /decompile option while holding down the Shift
key.

5 Close Access after the database window is displayed.

6 Restart Access normally while holding down the Shift key

7 Compile the database

8 Compact and repair the database.

Hope this helps you out.
 
Back
Top