By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

New behavior in Switchboard form

Alireza355
P: 86
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.CurrentProject.Connection

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.microsoft.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 veryyyyyyyyyyyyy much
Feb 16 '12 #1
Share this Question
Share on Google+
6 Replies


NeoPa
Expert Mod 15k+
P: 31,485
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 :-)
Feb 16 '12 #2

Alireza355
P: 86
Dear NeoPa,

Thank you very much for your reply.

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

I am still stuck!!!
Feb 17 '12 #3

NeoPa
Expert Mod 15k+
P: 31,485
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?
Feb 17 '12 #4

Alireza355
P: 86
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.
Feb 18 '12 #5

Alireza355
P: 86
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. :(
Feb 19 '12 #6

NeoPa
Expert Mod 15k+
P: 31,485
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.
Feb 20 '12 #7

Post your reply

Sign in to post your reply or Sign up for a free account.