Buy Access 2010

[Dick7Access]

My client has Win XP and it will not run Access 2013. All the stores have taken 2010 of the shelf. I tried Googleing it and the only one I found was to order the whole office suite. Anybody know where he can buy just 2010?

 

[Galaxiom]

As much as some people wish it they can't really stay on XP forever. XP reaches end of life mid next year. Time to move on.

 

[Dick7Access]

Yeh! Can't argue with that. I have gone thru every version of Access, but he has a very limited software budget, and he will have to go to Win 8 and them update lots of other software. Then of course why upgrade your software on a old computer. On top of that he is afraid of the learning curve. His best bet at this time s to just find a source for 2010.

 

[Dick7Access]

Does the client actually need to work in design mode? Perhaps he can get by with the runtime engine which is free.

BTW - A2010 has problems on XP and since XP is no longer supported, you won't get any MS help with it.

Thanks Pat! No he absolutely, will not, can't, and I don't want him to get in design mode. What do I have to save his db as?

 

[Alansidman]

Dick,
In addition to what Pat has offered up, here is a very good site about RunTime.

http://hitechcoach.com/

Scroll down a bit once you reach the link. It is a very effective way to offer Access programs to clients.

 

[gemma-the-husky]

i take it you have A2010

just install it on your client, but don't licence it. after the trial period it will revert to runtime.

runtime IS a full version of access, but unlicensed

 

[Alansidman]

Dick
On another forum, someone else is having the same issue, but it is advertised at Walmart -- look at this link.

http://www.walmart.com/ip/Microsoft-Access-2010/14272897

Edit: Didn't read the whole thing. Says out of stock. But you might try your local Walmart and get lucky.

 

[Dick7Access]

i take it you have A2010

just install it on your client, but don't licence it. after the trial period it will revert to runtime.

runtime IS a full version of access, but unlicensed

Thank You very much. I will give that a trial. I called MS and they would not take my money to even license. One of the thinks I hate about puters constant up dates.

 

[Dick7Access]

i take it you have A2010

just install it on your client, but don't licence it. after the trial period it will revert to runtime.

runtime IS a full version of access, but unlicensed

Dave,
Will not loading my copy ask for my product key and after I enter it will it not say sorry that is already licensed to someone else and then not load. Now if I am wrong and it does load, am I right in assuming that what you said above is that after the trial period he will no longer be able to program (code) with it, which is fine as he doesn't want to code and I don't want him to.

 

[gemma-the-husky]

two choices

- ignore the registration. after 50 uses or whatever it is, it will revert to runtime

- register, which breaks copyright. MS do let you overlicense products. eg You are allowed to install office on both a desktop and laptop as long as you only use 1 at a time. there are also legitimate reasons for reinstalling - eg, computer breaks, and gets replaced. So MS will certainly accept a number of registrations on the same key, but at some point will refuse to register the licence key, when it has been used too often

Now You wouldn't want to over-register properly licensed software especially when you are a professional developer - but this just clarifies exactly what happens.

 

[Dick7Access]

two choices

- ignore the registration. after 50 uses or whatever it is, it will revert to runtime

- register, which breaks copyright. MS do let you overlicense products. eg You are allowed to install office on both a desktop and laptop as long as you only use 1 at a time. there are also legitimate reasons for reinstalling - eg, computer breaks, and gets replaced. So MS will certainly accept a number of registrations on the same key, but at some point will refuse to register the licence key, when it has been used too often

Now You wouldn't want to over-register properly licensed software especially when you are a professional developer - but this just clarifies exactly what happens.

I am not sure you can call me a "professional developer", but I am a developer?????? thanks

 

[Dick7Access]

Are you having a problem downloading the free runtime engine? Is that why you are considering installing the full version using your own CD? I don't ever install demo, trial, or unlicensed software on my "production" PCs. I would recommend just downloading the funtime and installing that. When it comes time to uninstall, it will be clearly marked as the runtime so you will know what to uninstall.

Yes I have download runtime twice but can't locate the exe, and this foolish search on my win 7 won't pull up files that I know are there. In the meantime my client came into town and we were able to load 2010 onto his computer from my disc. According to others after so many openings it will turn into a runtime, so that should make it legal. I tried to pay MS for another license but they are not excepting payment for 2010 as they want to sell 2013. To make matters worse I went to Staples to buy 2013 so I can start studying it only to find out that MS no longer provides disc and it has to be downloaded. Not wanting to take a chance of buying a product that I would have trouble downloading I told Staples I would pay them to download it. Well, there so call MS certified tech couldn’t download it, and after I got home I found that I could no longer get into visual basic. It says that it cannot load VB6ext.OLB. I went back to Staples and the tech had left so I have to go back in the morning, and I am getting ready to leave for meetings in LA and TX. I am tempted to do a restore but they screwed it up let them fix it. On the funny side, (there’s always a funny side) my client thinks I am a whiz kid. If he only knew what is availed on Access Forum he would know better.

 

[Dick7Access]

When you are doing the download, select save as so you can direct the download to a specific location. If you just click save, I think it ends up in a folder named Downloads but I'm not sure what the higher level path is.

When I use to use IE it would let me choose the folder to put it in. With FireFox it puts it in C: > User > Me > download. (pain) When I open run setup, a Dialog box opens (Change your installation of Microsoft Runtime 2010) it give me these options 1. Add or remove features, 2. Repair, 3. Remove, 4. Enter product code. I have searched under my C:/ and cannot find the .exe. file

 

[Dick7Access]

According to the so called “MS Certified” tech at Staples the reason that I cannot pull up “runtime” is that I already have A 2010 on my machine, and “runtime” will only run if the machine has no Access or an earlier version of Access. Anybody know if that is true? He also fixed my visual basic problem by doing a repair.

 

[gemma-the-husky]

i don't understand your last comment

what do you mean by "pull up runtime"?

 

[Dick7Access]

i don't understand your last comment

what do you mean by "pull up runtime"?

Sorry, I should have said I can't open a runtime version so that I can see how my app will look to the user on his runtime version.

 

[Dick7Access]

Even if Access is too smart to actually use the runtime engine when you have Access retail installed, you still should be able to find the download file. The actual file name is AccessRuntime.exe.

You can change your Windows Explorer settings to show extensions (I can't figure out how people can work with extensions hidden) and show hidden system files. The .exe you downloaded isn't a hidden system file so I'm not sure how that would apply.

If you know the default download location, you should be able to find the file.

Once you find it, DO NOT install it on your computer. It will only cause confusion. Only install it on computers that do not have Access at all or that have older versions of Access.

BTW - I never let users have multiple Access versions installed if I can help it. It is just too confusing to always get that pesky .....installing...... message as Access fights for control over the registry with whatever version was previously installed. For development, I have one PC with multiple versions for cross testing but I am careful as I switch and so haven't run into problems. The A2010 runtime can run older versions so if the users don't actually need full Access, just get rid of all old versions.

My etension are showing and the the two runtime I downloaded show application but also the icon is a set up icon. Since the user is now up and running I am going to forget about runtime on my machine. Are you recommending I don't put 2013 on my machine along with 2010?

 

[Dick7Access]

To view your app as if it were under the control of the runtime engine, you have two options.
1. change the extension from .accde or .accdb to .accdr. This tells Access to pretend to be the runtime engine even if it isn't.
2. create a shortcut or bat file to open the database and follow the database name with the /r switch which also tells Access to pretend to be the runtime engine.

Dick, for your purposes, you can load multiple versions. Just make sure you never have two databases with different versions open at once. I haven't loaded A2013 so I don't know if it has any extra problems that older versions don't have. Just be aware that whenever you switch from one version to another you will get an ......installing..... message that could go on for a minute or more as one Access version fights with another over possession of the registry.

Others have said here and at Staples that 2010 and 2013 are compatible on the same machine, an at first I thought you were saying different, but I get it now just not both running at the same time. I want to get a jump on 2013 before someone ask for a db in 13 .I have worked my way up thru every version. Doses anybody know if this is one of the little changes or a major over haul?
My problem right now is that Staples couldn't download it. If I get some time between meetings in TX there is a big computer store in Houston, I might try them.

 

[gemma-the-husky]

the files themseleves go in these folders

A2003 C:\program files\microsoft office\office12
A2007 C:\program files\microsoft office\office14
A2010 C:\program files\microsoft office\office15
A2013 C:\program files\microsoft office\office16 ???

I presume A2013 installs in office 16.

 

[Dick7Access]

the files themseleves go in these folders

A2003 C:\program files\microsoft office\office12
A2007 C:\program files\microsoft office\office14
A2010 C:\program files\microsoft office\office15
A2013 C:\program files\microsoft office\office16 ???

I presume A2013 installs in office 16.

As of right now I only have A 2010. The tech at my local office / computer store was not able to download 2013. I have found all version of acces in the directory you mention for years. It is runtime I couldn't find, however, it is no longer an issue has I have loaded a copy of my 2010 on the clients machine without registering it, and as you said it will turn into runtime.

BTY My local office/computer store is Staples Office Supply. Do you have them in the UK