Solved

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

Posted on 2011-03-23
11
2,756 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
  • 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
 

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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now