Switchboard Compile Error

[Guest]

We have an Access 97 database on our server, that has a simple switchboard.
We can open and use this OK from most of our network PCs (which are Win XP
with MS Office 97). However, one PC (Win XP with Office 97) persistently
gets an error when you click on a switchboard button...
'Compile Error: Method or data member not found'

Displayed with the error message is some code (I assume Visual Basic) which
I assume to be a default piece of programming to process the switchboard
(we've not written any VB ourselves). The instruction hilighted is a
dbs.OpenRecordset.

I assume there's some problem with that particular PC.. I've de-installed
and reinstalled Office 97, but it makes no difference. I assume that what
I'm seeing is caused by something on the PC that should be interpreting the
VB program, but is failing to do it correctly.

That PC can successfully open the native Access database OK, it just cant
get in through the switchboard.


Any ideas as to what's causing it, and what I can do to correct it,
gratefully received.

RS

 

[Van T. Dinh]

It sounds like corruptions in the References Collection.

See Douglas J. Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[Guest]

Many thanks. Most of that article was like a foriegn language (we're not
developers, so most of the stuff was very unfamiliar), but it mentioned
saving as an MDE file.... which works, and is accessible OK from every PC
(including the problem one). So I guess we have a workable circumvent.

Thanks and regards
Richard

 

[Van T. Dinh]

Beware that you need to keep the MDB file in a safe place for later
modifications if required as the design of an MDE file cannot be modified.

 

[Douglas J. Steele]

Glad to hear that you were able to solve your problem, However, if you're
running into References problems, converting to an MDE may actually make the
problem worse, not better, since there's no way available to fix References
problems on a machine-by-machine basis with an MDE.

I agree that the article gets pretty technical pretty quickly. However, the
first few paragraphs (especially the bullets under Quick Solution) are
usually all you need.