Problem with runtime accde 1

[jpl458]

Have an ap I would like to distribute but have only gotton so far, then a wall. Using Office 10 - windows 7 service pack 3. Have compiled the vba so It's clean, and downloaded the runtime module onto the machine without Office on it. I create the accde file, but when I open it on the other machine it get the following;

'The database cannot be opened because the VBA project contained in it cannot
be read. The database can be opened only if the VBA project is first deleted.
Deleting the VBA project removes all code from modules, forms and reports.
You should back up your database before attempting to open the database and
delete the VBA project.
Crawled over the web and all I find is stuff about 2003, or performing a myriad ribly dll stuff that requies reading tem papers.

Does anyone know of a solution for this?

Thanks in advance

jpl

 

[lameid]

The issue is you compiled it with a machine with SP1 installed and the machine you are opening with does not have SP1 installed....

The best soultion is to ensure your environment is patched through SP1.

Alternately if you are only using 32 bit office, you can build your ACCDE on an unpatched system and it will work on both.

This is related to the fact that Office 2010 has both 32 and 64 bit versions. To make it compatable with both they ended up breaking backward compatibility for ACCDE's.

 

[jpl458]

Is that SP1 for windows or office or both?

I developed the ap on two different machines with the ap on a common database. Part of it was built on a 64 bit machine and the rest on a 32 bit machine. The user pc is 32 bit. (The 64 is home, 32 is at the office). I will move all the objects to a new container on the 32 bit machine and make sure the user machine is updated to either or both SP1s.

Thanks so much

jpl

 

[lameid]

Office SP1 is the only service pack involved... that is not to say running unpatched Windows might not cause other issues. Each version is likely to have a different SP level available.

 

[jpl458]

The machine that I want to put the run time ap on does not have office, do I still need to put SP1 on that machine? I ve installed the run time bit on that machine. In unfamiliar territory, so pardon the basic questions.
But thanks for your help. You'r the only response I got.

Thanks

jpl

 

[lameid]

I would EXPECT (not sure) that if you built the runtime on a patched system with SP1 you would have a patched runtime and if you did not it would not be. I am also assuming the runtime is built from Access and not a separate download... Last I used it, you had to buy a separate package but I know it is free now.

I would also expect that if you run Windows Update on the machine with the runtime, you will be prompted to update it... Whether it says something specific about the runtime or something generic about Office 2010 SP1, I don't know.

 

[jpl458]

Just checked and the runtime machine is XP and is on service pack 3. It dosen't say anything about the run time except for the error message posted above. The runtime is a separate download that you have to install on machines that are to have runtime access aps on them. I had no errors on that install. I will check for an office update but since its XP I will just get the latest one.

jpl

 

[lameid]

To clarifiy, when I said Windows update I mean the update service that goes out and gets updates for all installed Microsoft products not Updates for Windows.