using access 2003 runtime

[marlan]

Hi!
I have a split access 2003 app. I want to run on some client computers: one running acc2007, and one dosen't have access instaled. I'v downloaded access 2003 runtime from http://www.alkia.net/index.php/Access-2003-Runtime-Download-by-Alkia.html and installed it on a computer running acc2007, and it went well. When i went to the clients computer (running winXP and Acc2007) I got the OLE server or ActiveX refernce error.

What can I do?

 

[vbaInet]

That sounds more like a problem with a control than an application error. But why would you install 2003 runtime if you already have the full 2007 running?

 

[marlan]

Thank you for your reply!

All I use are the standart Access controls, no Activex.

useing 2007 eather gives the same error or the VBA code will not respond to the button events.

In any case, I have the same problem on a computer that runs no Access.

 

[vbaInet]

Have you checked the references to ensure that none is MISSING?

Are you using a calendar control?

Do you have modules that possibly require a DLL?

 

[marlan]

Hi you All,

I'm realy lost, and would realy apriciate help on this one!

I've tested the app on a computer that runs access 2007 - the app loaded, but did not respond to any event, therfor I could not test all feachers. When I instaled the 2003 runTime from the above link - it ran OK.
on the client computers I got the above errors. My questions are two:

1. What references would be missing on 2007 for running a 2003 App?
2. How do I set references in the runTime?

 

[marlan]

Have you checked the references to ensure that none is MISSING?

When I checked it seemed to me I have all the same references. Could you pleas focus me on the references I should have on 2007 for running a 2003 App?
and again, how do I set references in the runTime?

Are you using a calendar control?

No.

Do you have modules that possibly require a DLL?

No, all Quite simple modules using arrays, DAO.Recordsets and SQLs.

 

[vbaInet]

In the VBA editor, you go to TOOLS > REFERENCES. If any of the ticked references begins with MISSING, then you should untick it. But do this when you've opened the db using the full Access 2007 version.

My main suspicion now is that you're storing images in one of your tables and are also displaying them too. Correct?

 

[marlan]

My main suspicion now is that you're storing images in one of your tables and are also displaying them too. Correct?

I have images on the forms, none stored in the DB. The one on the switchBoard appears fine .

 

[marlan]

In the VBA editor, you go to TOOLS > REFERENCES. If any of the ticked references begins with MISSING, then you should untick it. But do this when you've opened the db using the full Access 2007 version.

What do I do on the computer not running any Access? how do I make the references in the runTime?

 

[vbaInet]

In that case this is what you need to follow:

http://support.microsoft.com/default.aspx?scid=kb;en-us;832508&Product=a

If that doesn't work then it may be corruption, in which case you follow these steps:

http://www.eggheadcafe.com/software/aspnet/28691267/error-message-about-ole-server.aspx

What do I do on the computer not running any Access? how do I make the references in the runTime?

You cannot. What I explained to you was just to make sure you untick missing references, nothing to do with adding references. Were there any missing references?

 

[marlan]

In that case this is what you need to follow:

http://support.microsoft.com/default.aspx?scid=kb;en-us;832508&Product=a

WOW, I thought embedding the image was easier to deploy!
I'll check it and be back in a short while.

 

[Dairy Farmer]

Convert the app to 2007
Deploy using the FREE 2007 Runtime and Deploy tools form Microsoft.

See my sig for full info.

 

[marlan]

Yup, the embedded images seem to be the issue. Thank You vbaInet!

 

[marlan]

Convert the app to 2007
Deploy using the FREE 2007 Runtime and Deploy tools form Microsoft.

See my sig for full info.

I've seen the post when searching the forum befor I posted the qhestion, and it seems geate, thanks!

 

[Dairy Farmer]

The good things are:
You can use 2007 or 2010 to create your app. Work in an environment you want to.
Always make the app an .accde then rename to .accdr
Runtimes are free
The deployment tool works well and is very easy to follow
Your app looks so much more professional

I suggest that the Runtimes are added to the install rather than requiring the user to go download them.

 

[vbaInet]

Yup, the embedded images seem to be the issue. Thank You vbaInet!

No problemo!

 

[marlan]

Well, VBAInet, Dairy Farmer, and the rest of you experts, there still seems to be a problem...

I'v upgraded the app. to 2007, downloaded the 2007 runtime, nd installed it on a computer running win7.

All event in the App give me an arror message, as in the Attached file.

BTW, the MS Runtime site (here) says the sytem Requirements for the runtime is win Vista or XP SP2, not win7.

Any help Please?

 

[vbaInet]

"a problem"... coming from a different control.

See these:

http://support.microsoft.com/kb/907337
http://networkq.org/memberservices/accented.cfm

 

[Dairy Farmer]

Make sure that the folder the app is in is a trusted folder in Trust Centre.

http://www.access-programmers.co.uk/forums/showthread.php?p=1029652#post1029652

 

[marlan]

"a problem"... coming from a different control.

See these:

http://support.microsoft.com/kb/907337
http://networkq.org/memberservices/accented.cfm

Better late than never...
I have finaly instaled the program on client locations, and all works fine!...
Thanks again, vbaInet!