Solved

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

Posted on 2008-10-23
7
513 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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 Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
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 …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

809 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