Solved

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

Posted on 2008-10-23
7
518 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
[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
  • 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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 …

749 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