Solved

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

Posted on 2008-10-23
7
511 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Cloud file services can fill many different roles for your business. Often, the use of cloud file services begins with employees using consumer products, like Dropbox, to share files with customers and each other. While sync-and-share can be an effe…
Outsource Your Fax Infrastructure to the Cloud (And come out looking like an IT Hero!) Relative to the many demands on today’s IT teams, spending capital, time and resources to maintain physical fax servers and infrastructure is not a high priority.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

919 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

15 Experts available now in Live!

Get 1:1 Help Now