?
Solved

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

Posted on 2011-03-23
11
Medium Priority
?
2,969 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 85
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

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 85
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

600 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