Solved

Database will not open with a  shortcut icon

Posted on 2013-11-20
7
99 Views
Last Modified: 2015-03-06
Hi,

One of my schools has just been upgraded tom Access 2003 to Access 2010. Their database is on a shared network drive accessed by about 10 simultaneous users. This all worked fine until the upgrade and they have told me they saw a message about security and clicked Yes helpful support information but that's all I have. Now what happens is the first user accessing the database can open by double clicking the database icon but all others after the ldb file is created have to run Ms Access and then select File > Open.

They are also getting multiple backups being created automatically.

Any help appreciated.

Tricia
0
Comment
Question by:tmckeating
  • 2
  • 2
7 Comments
 
LVL 6

Expert Comment

by:ButlerTechnology
Comment Utility
Is Access 2003 still installed on the systems or do they have the runtime installed?  I worked with a recent client that had 2003 system installed on their system.  They reported similar errors.  I had the one use open the database directly with 2010 which told the system to use that flavor of access by default.  The issue came back when the user open a different database short-cut that had Access 2003 hard-coded.  

Tom
0
 

Author Comment

by:tmckeating
Comment Utility
Yes 2003 is still installed for curricular reasons as some pupils are part way through a course.

What do you mean by one use open? How can you tell it to use 2010 by default. The database itself was 2003 format so I save and published it to the latest version and this appears to have worked but I am not confident.
0
 
LVL 6

Expert Comment

by:ButlerTechnology
Comment Utility
I believe that Windows makes the last open version of Access the default.  In this case, I am referring to opening Access without the focus of a database.  In my case, I had one user, Kerry,  who have both versions (2003 and 2010).  The secretary would be using the system and Kerry would attempt to access the shared database and nothing would happen.  We had the secretary close the database and Kerry would then be able to access the database.  This is when I noticed that Access 2003 was the default version on Kerry's system.  We opened Access 2010 from the start menu and it did a few things- not really sure but I am going to assume it is application related.  With Access 2010 being the default version, everyone is now able to work with the database at the same time.

With that being said, I think that having both versions is the cause and that removing the previous version isn't an option.  You could hard-code in the Access 2010 executable path in the short-cut for the database; this will force 2010 to be used.

Hope this gets you to a solution.

Tom
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
There's a registry entry fouled up somewhere by 2010.  Problem is, I haven't figured out which one yet.

 I have the same thing at one client; first person in, no problem.  You can open a MDB by double clicking on it or a shortcut.

 After that, everyone else needs to open Access, then do file/open in order to open it.   If they double click it directly, then nothing happens.

  Other odd thing that happens there is if you open a DB, then double click on Access on the task bar; it's opens another instance of a specific DB each time.

 This all started after someone installed and launched 2010.  I have since un-installed it, but the problems remain.

 This client currently has Access 2000 and 2003 installed, which gives me an idea....2000 didn't have the self-repair features like later office versions.  2003 did.  They don't use that much.  I'm going to try launching it and see if it cleans up the registry entires.

Jim.
0
 

Accepted Solution

by:
tmckeating earned 0 total points
Comment Utility
Since I did  Compact and repair all seems to be ok. Just waiting to see if it lasts.

Glad its not just me :-)
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

772 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

10 Experts available now in Live!

Get 1:1 Help Now