Access running on Windows 7

[Hap007]

Hi,

I have a rather large MS Access application that is written in Access XP /2003 version
Access seems to install in the Program Files Folder
The original author whom wrote the Access application installed the Application in \Program Files\AppDirectory

Now, on a Windows 7 system
Everything seems to get loaded to \Program Files (x86)folder

The application also gets loaded to \Program Files (x86)\AppDirectory

Problem, the app when loaded into the (x86) folder does not work.
If I install the MS access mdb into folder \Program Files\AppDirectory, it appears to work, but I then can no longer change the code in the Access MDB file.

Can anyone shed a little light on the older version of MS Access and how to run these programs in Windows 7

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

 

[dhookom]

I don't recall which folders are recommended for Access application installs. Try to create and delete files in a folder prior to ever installing apps. I expect security issues are your problem.

Duane
Hook'D on Access
MS Access MVP

 

[jrbarnett]

Hi Hap,

I haven't tried running Office XP/2003 on Windows 7, but I have found that the C:\Program Files (x86) only exists on 64 bit systems, on a 32 bit version you don't get that folder.

Suggestion from what we do
- put Access itself in the default MS Office folder
- put the application in a folder from a network drive and run the mdb from there
- see if the application can run under the Access 2007 runtime, this will have been tested a lot more on Windows 7 than Office XP, so you then only need a full copy of it for further development work.

http://www.microsoft.com/en-us/download/details.aspx?id=4438

John

 

[missinglinq]

Has your Folder been declared as 'Trusted?'In versions 2007/2010, the Folder holding the database has to be designated as a 'trusted' location.

To trust your folder, click:
* Office Button (top left)
* Access Options (bottom of dialog box)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)


The Missinglinq

Richmond, Virginia

The Devil's in the Details!