Cannot use database on certain machines...

[amazing66]

I have created an Access 97 db and subsequently created an MDE file from this. This application runs perfectly on my machine, however when an attempt is made to run this application on certain other machines (also running Access97) the app falls over, citing error messages as follows:

#1: "There is no object in this control" and
#2: "The expression On Load you entered as the event property setting produced the following error: Automation error.
* The expression may not result in the name of a user defined function or [Event Procedure]
* There may have been an error evaluating the function, event or macro.

The only code I have in the form 'On Load' event is:

Private Sub Form_Load()
    DoCmd.Maximize
    cmdRunReport.Enabled = False
    
End Sub

I have tried commenting this Form_load code out but the error still occurs. I have also tried running the 'parent' .mdb file by itself, but even this will not open properly on the problem machines. What is going on? Is there a local setting on these machines that could be causing the problem? Any information would be greatly appreciated.

 

[cthaxter]

I have a similar problem. Does anyone have any solution for this? Or since you posted this question quite a while ago, did you ever come up with a solution? There seems to be some difficulty running reports on other machines. But not on all machines.

 

[sfvb]

I don't know if this will help you, but the two most common causes of this type of problem, in a business environment are, different Operating Systems and/or different service packs. From there it can be a number of different things, including different versions of DLL's. Usually a programmer has more up to date software on his/her machine than the average user does.

Provided that both machines are at the same SP, your best bet is probably to go to Microsoft's Knowledge Base, and see if there are any known causes for these errors.

Steve

 

[Lightning]

Check the references on the problem machine. Open any mdb file on that machine, open a module in design view.

From the menu bar, choose Tools|References. Compare the displayed list with the same list from the original machine, adding any references needed to synchronise the two.

Shut down Access on the problem machine and then open your mde.

HTH
Lightning

 

[JoaoTL]

Hi, maybe you have the MDE as read-only, change it to Archive. Best Regards

---
JoaoTL
mail@jtl.co.pt
My MS Access Site:

http://www.jtl.co.pt