Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2011-03-23
11
Medium Priority
?
2,918 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 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
New style of hardware planning for Microsoft Exchange server.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

704 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