Solved

Database will not open with a  shortcut icon

Posted on 2013-11-20
7
108 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
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

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.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
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 …

778 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