Access under different OSs

[Les Isaacs]

Hi All
In the office we use an access2010 accdb, on 10 workstations all running windowsxp(32bit). As we start to replace the PCs they will come with windows7 or windows8 - 64bit. I did a global search and replace in all modules to add the PtrSafe parameter to all declarations, and the accdb then worked on the W7 PC I tried it on, but

1. After closing and re-opening the PC, the PtrSafe parameter had gone
2. We need to app to run on new and old PCs - is there a way of having the declarations conditional on the PC's OS?

This must be a common problem - but I can't find the solution: hopefully someone here will know
Thanks in advance
Les

 

[Beetle]

As we start to replace the PCs they will come with windows7 or windows8 - 64bit.

The 64-bit version of Windows. That doesn't mean they will have the 64-bit version of Office. That's where the issues come in to play, when trying to run 32-bit Office programs in the 64-bit version of Office. You should have no problems on a 64-bit OS as long as you use the 32-bit version of Office.

 

[Pat Hartman]

Both the 32-bit and 64-bit versions of Office come on the installation CD. Even though your OS will be 64-bit, it is best to stick with the 32-bit version of Office until you are completely upgraded since the two versions of Access are not compatable. Once your office is all 64-bit OS, you can change to the 64-bit version of Office although there may still be issues if you use add-ins that are 32-bit since you will lose them.

 

[Les Isaacs]

Hi Sean/Pat

Thanks for your replies. I hadn't realised that it's the office version that matters, so thanks for the info.

I do in fact have a laptop with Office 64-bit, so still need to sort out the declarations. I know the app works on the laptop with the PtrSafe parameter added, because I've done it, but it would be really helpful if I didn't have to do it manually each time (the app is regularly being updated, and I need to run the latest version on the laptop. Is there a way of making the declarations conditional on the Office version (32 or 64 bit)?

Thanks again
Les

 

[spikepl]

Perhaps: http://office.microsoft.com/en-us/access-help/HV080755465.aspx