"Error in Loading DLL" when opening Access2000

[Alan]

I developed an access2000 database on a Windows98 machine.
Then moved the .mdb file to Windows2000 machine with
Access2000. All worked just fine. I made a few
improvements and copied the .mdb file back to the Windows98
machine. When I open the database I get "Error in Loading
DLL". The window banner of the error says "Microsoft
Visual Basic". I'm still able to open the forms, tables,
and reports, but I can't use the "Switchboard" form.

Any ideas?

Alan

 

[Guest]

What code? I didn't write any code. If I move the file
back to the Windows2000 machine, all is well.

 

[TC]

Try & find the line of code on which the error occurs. For example, put
"msgbox 11" and "msgbox 99" at the start and end of Form_Load (if it has
that event). If you see 11, then 99, then the DLL error, you know that it is
occuring >after< form_load, so just refine your tests accordingly.

HTH,
TC

 

[Alan]

I'm Sure it does. How do I find/open it? WHen I go into
Design View it just shows the layout of the "Sitchboard".
I see no code. Where do I look?

 

[TC]

You say that you can't use the Switchboard form. Surely the Switchboard form
contains some code?

TC
(off for the day)

 

[TC]

Open the form in design view. Then look at the toolbar buttons across the
top of the screen. One of them will take you to the "code module" for the
form. That's where all of the Visual Basic For Applications (VBA) code
resides, for that form.

HTH,
TC