Database will not open with a shortcut icon

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
tmckeatingAsked:
Who is Participating?
 
tmckeatingConnect With a Mentor Author Commented:
Since I did  Compact and repair all seems to be ok. Just waiting to see if it lasts.

Glad its not just me :-)
0
 
ButlerTechnologyCommented:
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
 
tmckeatingAuthor Commented:
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
 
ButlerTechnologyCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.