Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Database will not open with a  shortcut icon

Posted on 2013-11-20
7
Medium Priority
?
115 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 58
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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
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…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

972 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