moving an access DB from a machine to another: "no object msg" 1

[davikokar]

Hallo,

I moved an access DB from a machine to another machine (both have access 2007 installed). When I launch the db in the new machine I get an error "there is no object in this control". It has to do with an activex object that's in use in the db (a treeview control). I don't know what I should do to make access working in the new machine. Do I have to move some .dll files? Register things? If yes what? How? Or I just cannot move an access db that uses some activex objects?

thanks for helping

 

[MajP]

Make sure on the new machine you update all your windows and office service packs.

The tree view control is part of the MS Common Controls 6.0. After updating the new machine. In your VBA window. Go to Tools, References, and look for
mscomctl.ocx
It should be checked. This is the reference to the control. If not selected, select it. If it is selected uncheck it. If it is not in the list browse to windows/system32 and select it.

 

[davikokar]

In the new machine I do have a reference to MS Common Controls 6.0 (SP6). The file mscomctl.ocx is exactly the same on the two machine.

I unchecked and then checked again. But the error message stays there.

In the treeview properties I see that the "OLE Class" property is set to "TreeCtrl" and the "Class" property is set to "COMCTL.TreeCtrl.1. Maybe this information is important.

 

[MajP]

Normally these are self registering.
If you can, delete the control, and then add it back in. make sure to use the same name so your code still works. The control is found under "More Controls" and I think the name is MS Treeview or Microsoft treeview.

If adding a new control does not work. Try registering the control in the run window.

regsvr32.exe <path_to>mscomctlx.ocx

 

[MajP]

looks like this to add back in

http://tinypic.com/r/2mfybf5/5

 

[MajP]

However, if you can please update all windows and office service packs it will make trouble shooting this far easier. I would not even start trouble shooting until all Access 2007 Service packs are updated. See discussion.

http://allenbrowne.com/Access2007.html

 

[davikokar]

deleting and re-adding the control worked. Thanks