Solved

dao3.6 in windows7 , How to install the right Version on Windows 7

Posted on 2011-03-23
11
2,850 Views
Last Modified: 2012-05-11
I have a Strange Problem
MSAccess 2002 Application that Runes with DAO3.6
is working fine on all Windows OS

But I have a problem with one windows 7 32Bit
I get strange Problems with the Database
I checked all references and there is a Problem with the DAO reference
As I checked more I see that the
C:\Program Files\Common Files\microsoft shared\DAO\dao360.dll
Version on this machine is 3.60.9756.0

I check the version on other Windows7 and the version is higher

I tried to use regsvr32 /u C:\Program Files\Common Files\microsoft shared\DAO\dao360.dll
And to delete the file, but I can't do this I get error message that the file is in use

Any solutions?
0
Comment
Question by:DoronAviad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
  • +1
11 Comments
 
LVL 44

Expert Comment

by:GRayL
ID: 35202414
Did you shut down all Office apps before trying the delete?  Personally, I would not delete but rather rename or move.
0
 

Author Comment

by:DoronAviad
ID: 35202551
I found How to delete
it seems that windows 7 dosent give you ownership on all the files
So I took ownership and change security so I can delete the file
0
 
LVL 84
ID: 35202640
I would also STRONGLY encourage you to not arbitrarily delete/rename important files like this. Intstead, use the various upgrade options to insure that you're running the most current Windows updates, Office updates, etc etc.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:DoronAviad
ID: 35202698
I tried But It Dosen't work
0
 
LVL 1

Expert Comment

by:stephenlecomptejr
ID: 35204728
All the research on the web states that Access 2002 is incompatible with Windows 7.
http://answers.microsoft.com/en-us/office/forum/office_xp-office_install/access-2002-loaded-on-windows-7-64-bit-not-working/974a8552-7a50-4ae3-84c1-e80923db63fd

http://www.microsoft.com/windows/compatibility/windows-7/en-us/Search.aspx?l=en-us&type=Software&s=office%202002

One guy found a solution here at the following url: http://www.techsupportforum.com/forums/f217/solved-accessing-old-access-2002-database-within-windows-7-a-531311.html

But its not concrete which solution worked for him - its either using Open Office or installing an old Office XP or newer version of Access to open the file in Windows 7?

Another solution somewhere was updating the Novell software for their network but doesn't say client or server?  So not sure if you have that or not...

Then finally...

I would even see if you can go to the working Windows where the file works - save down to another version of Access for the file - even if it could be Office XP or earlier - compact and repair the results - it then transfer it over and see if it works in Windows 7.
0
 
LVL 84
ID: 35206310
Hmmm ... I overlooked the 2002 tag. Stephen is right - 2002 is NOT supported on Windows 7, so understand that any fix you come up with would be subject to failure due to future updates, service packs, etc etc. You would be much better off installing a supported version of Access and use that.

That said: You might be able to use XP Mode for the Windows 7 box, or try to set the Compatibility Mode for that specific version of msaccess.exe to see if you can get things to work
0
 
LVL 1

Expert Comment

by:stephenlecomptejr
ID: 35208496
I'm sorry to post this again but maybe lost in the translation above...

I would try to save down the Access version to Access 97 or if possible (I could be wrong in this) Office XP version is that available, not sure?  Just try anything other than Access 2002 and then do a compact and repair after.  Then try that version on Windows 7 to see if it works.
0
 

Accepted Solution

by:
DoronAviad earned 0 total points
ID: 35276548
Thanks all for helping

but the only sullotion we found was to reformat the windows7 computer and now it works fine
0
 
LVL 1

Expert Comment

by:stephenlecomptejr
ID: 35278608
Interesting!

I'm curious as to what version of Windows 7 it is?  Is it Windows 7 Professional, Ultimate or Home?
0
 

Author Comment

by:DoronAviad
ID: 35281659
Professional

It terms out that the same customer has 5 windows7 pc
3 Worked OK from the start (thay were new) 2 didn't work
I suspect that another installation of aold application overwrite DAO dll's and made all the problem
0
 

Author Closing Comment

by:DoronAviad
ID: 35321657
Only sulotion we found was to reformate windows7 computer
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question