Help My Database has stopped working!!

andy_dyer

Registered User.
Local time
Today, 08:47
Joined
Jul 2, 2003
Messages
806
Everytime I click on anything which runs some code 9which previously did work) I now get this:

"a problem occurred while microsoft access was communicating with the ole server or activex control"

Any ideas??

Thanks

Andy
 
Could be that a Reference has been unlinked. Make sure your references are what they are supposed to be.
 
What references?

On one form I have several on clicks, an on current etc etc and they have just stopped!!

Surely I can't have killed them all??

Thanks

Andy
 
Reference are links to dll's

In the code editor select Tools->References

since it is an ole error make sure that there is a check beside the OLE Automation reference.
 
It's checked!!

These are all those that checked:

Visual Basic For Applications

Microsoft Access 9.0 Object Library

Microsoft ActiveX Data Objects 2.1 Library

Microsoft Calendar Control 9.0

OLE Automation
 
Then I'm stumped. Had that error awhile back and that is how I got rid of it. Sorry I couldn't help you out further.
 
Try importing all your tables, forms etc etc into a new DB and then make sure all references are checked

IMO
 
Ok...

Some progress... everything seems to eb working apart from my calendar control...

The Active X Control was on the list to select so i browsed to the right .ocx file and added it... but they still don't work...

On the debug it says it doesn't recognise ShowCalendar as a function...

Any suggestions??

Thanks

Andy
 
Did you import everything into a new DB? If so, Is the Microsoft Calendar Control 9.0 checked in your references?

IMO
 
I had missed off the modules in my import!!

Thanks for your help, all working again...

Weird that it just suddenly corrupted on me...

Thanks again

Andy
 

Users who are viewing this thread

Back
Top Bottom