Help My Database has stopped working!! (1 Viewer)

[andy_dyer]

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

 

[MadMaxx]

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

 

[andy_dyer]

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

 

[MadMaxx]

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.

 

[andy_dyer]

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

 

[MadMaxx]

Try checking Microsoft DAO 3.6 Object Library

 

[andy_dyer]

Same error...

 

[MadMaxx]

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.

 

[IMO]

Try importing all your tables, forms etc etc into a new DB and then make sure all references are checked

IMO

 

[andy_dyer]

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

 

[IMO]

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

IMO

 

[andy_dyer]

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

 

[IMO]

Glad it's sorted

IMO