Error in odbrpt2000.mdb?

I can run any of the reports in odbrpt2000.mdb on my desktop. I also have ODB installed on my laptop and when I try to run any reports I get:
Microsoft Office Access: There was an error compiling this function. The Visual Basic module contains a syntax error. Check the code, and then recompile it.
It seems to be in the AttachAll() function.
I tried reinstalling Access in case my laptop had something strange going on but it didn't help.
Any ideas what I might be missing?
Thanks,

Becky Snyder
Whitney's Walk

Hi Becky,I'll need more

Wed, 06/27/2007 - 8:48am

Hi Becky,

I'll need more information to help you figure out what's happing on your laptop. Here are some questions:

Does the program stop inside the AttachAll() function?

Is a specific line highlighted?

Can you open odbrpt2000.mdb directly on the computer that has the problem?

If you go to the Visual Basic code window (Alt-F11) and select Tools/References from the menu, does anything show as "Missing"?

What version of MSAccess are you using?

Let's start with these questions and we can continue from here.
Take care,

Steve.

Thanks for your quick

Thu, 07/05/2007 - 7:28am

Thanks for your quick response. I was out of town last week.
Here's the sequence of events.

I 'run' the report and get the message:
'The Visual Basic Module contains a syntax error. Check the code, then recompile it'.

I click OK

Message box comes up with:
Macro Name: RunReport
Condition: True
Action Name: RunCode
Arguments: AttachAll()

I can open 2dbrtp200.mdb directly.
It does say that "Microsoft DAO 3.51 Object Library" is missing

I'm using Access 2003 SP2

I hope I'm giving you good info to help track this down. Thanks again!

Becky

Missing Microsoft DAO 3.51 Object library is the problem

Sat, 07/14/2007 - 9:00pm

Hi Becky,

Sorry it's taken me so long to get back to you on this.

The missing "Microsoft DAO 3.51 Object Library" is probably causing the problem. Do you have "Microsoft DAO 3.6 Object Library" in the references list? Try unselecting the 3.51 version, close the dialog, open again and selecting the 3.6.

Hope that helps.

Steve.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.