Solved

Internet Explorer Blocks Access to Microsoft Access

Posted on 2007-12-04
8
699 Views
Last Modified: 2013-12-08
When Microsoft Internet Explorer 7 is installed on network pcs, it blocks access to Microsoft Access.  Whether it's a automatic update from Microsoft or a manual install of explorer 7 it blocks users from accessing the Microsoft Access Database.  I have to uninstall explorer 7 in order for users to access the database.  I don't understand how a Microsoft product would block access to another Microsoft product.  It will open access files that are not being used by other users.  Only the main database that users log into will not open.  Can anyone provide me with some insight on this situation.  All users have Windows XP Pro and Office 2000.
0
Comment
Question by:livinlif3
[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
8 Comments
 
LVL 13

Assisted Solution

by:wiswalld
wiswalld earned 20 total points
ID: 20405464
Not sure of your problem I have XP Pro and Access 2003 on a machine with explorer 7.0 and no problems. Check Tools-Options_Advanced and see if it is set to shared for the default open mode.
0
 
LVL 66

Expert Comment

by:johnb6767
ID: 20405676
Are these local databases? Or just cant run start>run>msaccess.exe?
0
 
LVL 10

Assisted Solution

by:dragonjim
dragonjim earned 20 total points
ID: 20406029
Ok. You have a shared database, with clients running local copies of Office 2000 (Access being issue).
I haven't run across any issues with the permissions itself.

You might want to check:
1) File / Directory permissions for all users (Full Control?)
2) Are there database level locks (if 1 user is in, are others allowed in?)
--> More common is a record lock ... if user1 is in record 221; then user2 is told "sorry, another user is editing this record, please try again" -- protects against data integrity issues.
0
Scamming the Scammers!

Have you ever heard of Scam Baiting?
It's a highly entertaining sport that you can participate in.
Introduction to beating scammers at their own game and how you can help
Share your thoughts, ideas and experiences on the topic.
Links to top Anti-Scam resources provided.

 
LVL 3

Author Comment

by:livinlif3
ID: 20406202
Yes, this is a shared database on the network.  

1) users have full control of the database.  (everyone has full access, to folder)   I'm in the process of rolling over from a workgroup network to a domain)  The update affected domain users and workgroup users, there is a few users on the old workgroup setup, that I'm in the process of transfering to new domain.
2)  Multiple users can access the database at the same time.
3)  If a computer has internet explorer 7 installed, when you click on the shortcut to the database the database doesn't even show up.  Say for instance I take the database and copy it to the desktop on the computer,  I can then access the database.  (only the database that is in use by multiple users will not open)   Pcs that have internet explorer 7 installed can't access the database.  Why would internet explorer not allow me to access the database when internet explorer 7 is installed is beyond me.   I've searched high and low and don't see anyone having this type of issue.
0
 
LVL 66

Assisted Solution

by:johnb6767
johnb6767 earned 460 total points
ID: 20406245
Are you accessing from mapped drives, or UNC paths?

Have you put the server of the shared DB in the trusted zones?
0
 
LVL 66

Accepted Solution

by:
johnb6767 earned 460 total points
ID: 20406341
From "http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadID=204752&messageID=2149264"

We encoutnered this shortly after people upgraded to IE7.

A workaround is to get IE to not try and detect your local intranet zone.

- in Control Panel, run Internet Options
- Go to the Security tab
- Click the Local Intranet icon
- Click the Sites button
- Uncheck "autmatical detect Intranet Zone" box
- leave the others checked as per your preference (for me it's all three).
0
 
LVL 66

Expert Comment

by:johnb6767
ID: 20406352
Internet Explorer 7, Site Security, Mapped Drives argh!!
http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadID=204752&messageID=2126861

The full threads....
0
 
LVL 3

Author Comment

by:livinlif3
ID: 20665332
We encoutnered this shortly after people upgraded to IE7.

A workaround is to get IE to not try and detect your local intranet zone.

- in Control Panel, run Internet Options
- Go to the Security tab
- Click the Local Intranet icon
- Click the Sites button
- Uncheck "autmatical detect Intranet Zone" box
- leave the others checked as per your preference (for me it's all three)

This is the solution I was looking for.  It worked fine right after these directions.  It's crazy how Microsoft, would block access to one of their own applications!!
0

Featured Post

Increase your protection from Zero Day threats!

Running two Antivirus' is never a good idea.
Taking advantage of Multiple Security layers on the other hand can often save your hide.
See which top notch security software brands have been proven to happily coexist together.
Reduce your chances of becoming a statistic.

Question has a verified solution.

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

Suggested Solutions

In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
This Micro Tutorial will demonstrate how nuggets on the Web are formatted by using Chrome Developer Tools. These tools would not only view the site's CSS but it can also modify it and save the CSS to use on your own site.
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