Testing Access 2007 database under Runtime for Access 2010

[Lateral]

Hi guys

I am a newbie and have the full version of Access 2007 installed on my PC.

I would like to deploy my databases using the Access 2010 Runtime and would therefore like to test that the databases work fine under Access 2010 Runtime.

How can I do this on the same PC that I have 2007 installed?

Thanks for your help.

Regards
Greg

 

[Lateral]

Any replies to this guys?

 

[Lateral]

Somebody must have an answer to this.

 

[CJ_London]

I've not had to do this but here is a link to the Access 2010 runtime download

http://www.microsoft.com/en-gb/download/details.aspx?id=10910

You can try and install and see if this works OK. Not sure if it matters with the runtime but I would think you need to make sure you are using the same version (32bit/64bit) of office as your development machine since a 32bit version of access will not run on 64bit and visa versa.

 

[Lateral]

Hi, just to clarify. I'm developing a single user desktop based application and simply want to test it using the runtime only so that I can see exactly how it will appear to the end user c

 

[GinaWhipp]

What CJ_London is accurate. You need to download and install the Runtime 2010 version. Note, once you do so Access will then *configure* each time it opens AND will remember the last version opened. Other than that you will have no issues.

 

[Lateral]

Hi guys

Here's the update.

I installed Access 2010 Runtime.

If I want to run an accdb under the Runtime them I need to "right click" the file and do an "Opem with and choose the 2010 Runtime application.

If I then want to open the accdb in the Access 2007 developer environment then I do the same as above except I choose the Access 2007 application.

Regards
Greg

 

[GinaWhipp]

Right, but since Access does remember the last version opened, once you open 2010 you should be able open any other database in 2010 UNTIL you switch back...

 

[Lateral]

Hi Gina,

You are correct. The only issues is that when you switch back Windows tries to reinstall some stuff that can take some time.

 

[CJ_London]

Just out of curiosity - if you create a runtime version does the user still need MS Office installed? All the lookups I've done on the web say 'do not need access' not 'do not need office'.

i.e. if a user is using say lotus products for word processing/spreadsheets etc and does not have any office components installed - will it still run? - This assumes the system does not have facilities built in to import/export/link to excel files for example.

If the answer is complicated, happy to post this as a new thread.

 

[GinaWhipp]

Nope, the User does not need Office or any part installed UNLESS you are using Automation to some part of Office. (Probably a good idea to test your database on a clean machine or enviroment.)

P.S. Better to have the answer here, the OP might want to know also.

 

[CJ_London]

@Gina - thanks for that - I guess the next logical question is the OS the user is using - i.e. XP or later for Access 2007 or later runtime or pre XP for Access 2003 or earlier?

 

[GinaWhipp]

CJ_London... Better question, what OS are his Users using?

 

[Lateral]

Hi guys

The environment will probably be a single standalone PC with Windows XP or Windows 7. These may or may not have Office installed.

Regards
Greg

 

[GinaWhipp]

Oh, then you *should be* fine...