New behavior in Switchboard form

[Alireza355]

Hi everyone.

I have an access 2002/3 database that I have been using for 4 years with no problem but now, all of a sudden, I get this funny error in the Switchboard that says "error in loading DLL" and it seems to come from the code behind the switchboard form in the FillOptions procedure:

Set con = Application.Cur rentProject.Con nection

I think maybe a recent automatic update to Windows XP might have something to do with this. I googled a bit, and found an article :

http://support.microso ft.com/kb/262847

but this did not help me (even though I am not using office 97 or have never converted anything to anything else!!!

I would be honored if you could help me out, because the database is so huge and the switchboard is quite complicated for me to re-create it from scratch again.

Thank you veryyyyyyyyyyyy y much

[NeoPa]

No magic wands I'm afraid Ali, but I'd suggest you check on all the references for the Access install before rebuilding the switchboard. As a form, the switchboard is exportable, so exporting, deleting then importing again may be a quicker way than redesigning from scratch.

Good luck with it anyway :-)

[Alireza355]

Still need help

Dear NeoPa,

Thank you very much for your reply.

I think I need a little more assistance, if possible, please.

I am still stuck!!!

[NeoPa]

I don't think there's much more I can do for you remotely Ali. What did you find when you checked the references? What happened when you tried reimporting the switchboard from the exported files?

[Alireza355]

I will let you know as soon as possible, because I am out of town now. Thank you very much for your kind attention all the time.

[Alireza355]

Dear NeoPa,

I checked the references and here is what is checked:

Visual Basic for applications
Microsoft access 11.0 object library
OLE automation
Microsoft DAO 3.6 object library
Microsoft visual basic for applications extensibility 5.3


since I really don't know what these are, I can't say if there is anything wrong with these or not.

I have also tried exporting the switchboard to an empty database, then deleting it, and re-importing it but that was also no good. :(

[NeoPa]

If there had been any problems with the references then they would have shown as "Missing". Access flags this up for you. Obviously, you need to check them on the machine where the problems are occurring of course.

I wasn't suggesting exporting the switchboard to another database, but to a file. It may have the same results, but because it has to convert both ways I suspect there is still some point in checking what I suggested. I hope so, as if that doesn't help either, then I don't know what else to suggest for you. You may have to redesign the switchboard again from scratch :-( Not the code though, of course. That can always be copy/pasted across.