access 97 mdb not working, can i find out missing dlls ?

[haggo]

Hello

Could someone please help, At the company i work we use an access 97 application, which was made by an old tech who does not work here anymore

It is just an mdb file, 97 format, with forms, tables, sql etc

Normally i can just install access 97 and it works on everyones computer, apart from one..

It loads up some forms, however when editing, and a subform if clicked on and change, when saved an error comes up

"OLE SERVER ISNIT INSTALL, REINSTALL IT" THEN IT CRASHES

seems to be just on this one object

the codes fine because it works on everyones else, it there a way i can find out what dll files are need for this mdb to run ? anyone got any ideas

i dont have office devoloper, so i cant make a installer for it

i have tryed install access 97, office 97, office 2003, and works but this ole or object never seems to be installed ?

any help would be great, i cant work this one out

 

[The_Doc_Man]

From a machine where it works, see if you can open a Module page to make the Tools >> References dialog box come up. Then scroll through the entries in the box until you find the OLE item. At the bottom of the Ac97 references dialog box, you should see the file spec of the .DLL file including a path.

In all probability, this would not only have to be referenced correctly, but probably would have to be ActiveX registered, which is ALSO under the Module pane's Tools menu option.

That at least might tell you what you need. Got not a clue as to why something so basic as an OLE object wouldn't be on all machines, but then I don't work with OLE much.

 

[haggo]

did not work

Hello

thanks for the info, still not working

i still get the error, ole server init install, to install an ole server, reinstall it

this happens when, the user on that computer it on a form, which contains a subform, which itself is a standard form

their is a button called, edit, which must be click to start editing, then u edit as you want and then press a button saying "stop editing"

where this code is run

#################
Me.Order_Form_Subform.Locked = True
Me.Command71.Enabled = True
Me.AllowEdits = False
Me.Locked = False
Me.Command67.Caption = "Edit"
Me![UnlockOrder].Enabled = True
Me.NavigationButtons = True
Me.Refresh
##################

when the error comes up, and crashes access

i have checked the file ref's from code view, all seem to be there, i have unticked and ticked them, no problems there, they install, but no luck

still get the error

i have looked up and download the files which are ticked and un-regged them and re-regged them

still no luck

i have uninstalled access and office and uses a removal tools from microsoft and reinstalled all..

still the ole server is not being installed

.............................

the only strange thing is, that when i tryed to replace the STDOLE2.TLB file, it says, cant, is in use...

even when nothing is running ?

strange

any ideas people, is there a tool to look at a mdb file and tell me all the need files ? is they a access expert service i can call and pay for the phone call ?

i;m very stuck, anyone help please ???