Windows 8 1

[Hap007]

I was just asked by a client if MS Access 2003 and MS Access 2007 will run on a new Windows 8 PC

I do not have Windows 8 yet, so I was wondering if anyone had tried running the older versions of MS Office and MS Access on a Windows 8 operating system

1) Does it work?
2) If it works, are there any major issues?


My client has a great deal of older MS Access Apps and wants to upgrade their PCs but does not want to change the MS Access VBA program code.

Thanks,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[1DMF]

Yes, well, I actually run MS Access 2010 runtime with 2007 format access applications wrapped up as an ACCDR.

This works fine on Windows 8/8.1

Converting Access 2003 -> 2007 is a simple process and shouldn't require any VBA code changes, its just a simple convert option in the MS Access IDE, though make sure you backup any Access file before doing any conversion, just in case!

The only thing that doesn't work with the latest MS software is the cloud (Office 365), as long as you have a desktop version of Office (currently 2013), it all works fine on Windows 8/8.1 , Though we only have Office 2010/2013 on the laptops that do have Windows 8, so cannot say if Office 2003 would work on Windows 8, MS's official statement I believe was Office 2003 won't work on Windows 7, but it does!

Though if this is a corporate environment with mix mode PC's connecting to a corporate domain server, I have been advised by our server support company NOT to get Windows 8, and stick with Windows 7, as Win 8 doesn't play nicely with the domain server or a mixed client OS environment - I haven't confirmed this advice, so it might be worth looking into yourself. No one I know likes Windows 8, so sticking with Win7 is a better option for us anyway!

So be sure everything else will work for your environment before going full steam ahead with new Windows 8 machines, running MS Access will be the least of your problems!

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music

 

[Hap007]

Thanks for the heads up.

I support an old accounting system.
This accounting system was originally written in MS Access 97
Then, later versions were released written in MS Access 2000, 2002, 2003

Each release had additional features and the purchaser was given the source code.
Many purchasers revised the source code for the version the purchase, sometimes major revisions

Bottom line, I have needed to convert older versions of MS Access to later versions.
I have also installed older versions of MS Access, such as Access 97, on Windows 7 PCs

This seems to work, but the original Access programs were expected to sit in the Programs folder

So, when I install the mdb's and mde's in the Program Folder of a windows 7 PC, I seem to have security issues unless I first copy these files to the documents folder and then copy the files to the Programs folder

This accounting application has a Menu program in access and about 75 additional mde files that are called by the menu program, so changing the folders is not an easy option.

Any suggestions on how and where to install the access mdb and mde programs on a Windows 7 PC would certainly be welcomed.

FYI,
This app uses MS Access (and much VBA code) as a front end
The back end storage of data can be MS Access, MS SQL or MySQL

Thanks,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[1DMF]

You can fix your security issues by installing Trusted Locations reg keys

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location1]
"Date"="01.01.2014 00:00:00"
"Description"="My Access DB Name"
"Path"="C:\\My Access DB Local Folder\\"
"AllowSubfolders"=dword:00000001

You will need to replace the Office number (14.0 = Access 2010), relative to the version of the DB you are using and if you have more than one application, just add another Location..

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location2
....
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location3
....

The annoying security prompt will go away once you correctly configure a trusted locations registration setting.

As always if you ever edit the Windows Registry be very very careful and always make a backup first!

The easiest way is manually create a trusted location key in a text editor, save it with .reg extension, put on the users desktop and double click to install!

Now you can put the application where ever you want and then simply authorise it with the reg key - simples!

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music