Solved

MS Access won't open from a hyperlink on a webpage

Posted on 2008-10-23
7
505 Views
Last Modified: 2013-11-22
We have a webpage that contain links to a MS Access databases (2003).  Clicking on the link is supposed to open the database.  This is no longer working.  If you go into TaskManager you can see that an instance of MSAccess was kicked off (running on the client machine) but is getting no CPU time and never opens.  These links were working at one time.

The link in the webpage is set as:
 <a href="file://Bopper/IDMQuality$/IDM%20Quality%20Reports%20Database/IDM%20Quality%20Dashboard.mdb">

Any suggestions would be greatly appreciated.
0
Comment
Question by:bkrbbnsEE
  • 4
  • 3
7 Comments
 
LVL 20

Accepted Solution

by:
edster9999 earned 250 total points
ID: 22786967
Do you have access to the file and to that folder ?

1. Go into access and try to open it using the same path.

2. Close access and try typing the path into the top bar of a window like 'my computer'

"//Bopper/IDMQuality$/IDM Quality Reports Database/IDM Quality Dashboard.mdb"
Note I have put double quotes round it - leave those on and I have converted the %20 back to spaces.

Try opening a network file name with no spaces.  Put a file in the IDMQuality folder called file.mdb or something like that and see if that works
0
 

Author Comment

by:bkrbbnsEE
ID: 22787785

Thanks for the suggestion any and all are appreciated!

I can map to the actual sharedrive the database resides on and open it by double clicking on it.  I did try changing the name to remove the spaces and updated the link appropriately but the results were the same.
0
 
LVL 20

Expert Comment

by:edster9999
ID: 22788245
How about 'repair access'.  It is a tool under help (or somewhere) in the menu and it corrects any missing or over written files in the install

0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:bkrbbnsEE
ID: 22795431
The compact and repair option was one of the first things I tried.  This Access database has a number of  local tables and a number of linked tables.  And, it is pretty large. 669,656 kb after compact and repair.
I tried creating a link to a separate asp page that ran a script similar to the below script it.  Didn't appear to help.

<Script LANGUAGE="VBSCRIPT" >
      Dim objWindowShell
      Dim strPath

      Set objWindowShell = CreateObject("WScript.Shell")

      on error resume next

      strPath = ":\\Bopper\IDMQuality$\IDM%20Quality%20Reports%20Database\IDM%20Quality%20Dashboard.mdb"
      objWindowShell.Run strPath, 3
      Set objWindowShell = nothing
          On Error Resume Next ' Turn error checking off.
          parent.opener=top
          close()
          On Error Goto 0      ' Turn error checking on.
</Script>
         
Could the problem be multiple users?  
0
 
LVL 20

Expert Comment

by:edster9999
ID: 22795666
No - I was talking about an option to repair the access program install.  It is either under the menus inside the program (maybe under help ?) or in control panel click add remove program select access (or office pro depending on how you installed it) and select 'repair'

Multiple user can be a problem opening database but I think you normally get an error.   Remove this line (or comment it out)
On Error Resume Next ' Turn error checking off.
and see what happens
0
 

Author Comment

by:bkrbbnsEE
ID: 22796424
I can try repairing the access install.  However, multiple users are experienceing the problem so i don't think it's tied to a install issue of Access.

I've been trying a combination of the script and your first solution, moving the database to a location that the path contained no spaces in the name and removed the spaces from the database name.  This appears to be working.
                 Thank you very much for all your help!
0
 

Author Closing Comment

by:bkrbbnsEE
ID: 31509240
this solution in combination with executing the vbscript in a separate asp page.
0

Featured Post

Free Trending Threat Insights Every Day

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.

Join & Write a Comment

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

757 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

19 Experts available now in Live!

Get 1:1 Help Now