Solved

Database will not open with a  shortcut icon

Posted on 2013-11-20
7
110 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
[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
  • 2
  • 2
7 Comments
 
LVL 6

Expert Comment

by:ButlerTechnology
ID: 39662148
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
ID: 39663835
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
ID: 39663888
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
ID: 39663924
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
ID: 39670339
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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Suggested Solutions

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

740 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