Access 2007 crashes on the network

[riit]

Our Access 2007 database is constantly crashing on the network. The database has a 2007 shell linked to 2007 data tables on the same drive. Network has 1200 pcs and about 120 users - shell is about 120mb. Our repair involves copying a clean master shell - relinking to the data tables - creating a new shortcut and deploying the new shortcut across the network. This database was running last year OK in Access 2000 - in the summer the network was upgraded to Access 2007 and our problems started. At first the database was still in Access 2000 so we converted it to 2007 - still the same problem - next we rebuilt the database in 2007 by importing the objects from the 2000 database - stil we are having the same problem. Is it being caused by a rogue installation or 2 of Access 2007 ? When the database goes down it automatically creates a backup of the shell so we know when a problem has occurred. Any suggestions would be most welcome

[RuralGuy]

What is the shell? Is it the Front End for the Access system?

[riit]

Yes the shell is the the front end access database without tables

[RuralGuy]

Does everyone have their own copy of the "Shell"? They should not be using the same FrontEnd but a separate copy of it that is on theor PC.

[riit]

Thanks for your interest

no one has access to the front end shell except the administrator. The shell and the linked data tables sit on a virtual drive which cannot be accessed by users. they only open the front end via the shortcut deployed to their desktops

[RuralGuy]

It sounds like everyone is using the same FrontEnd which can be very problematic.
http://www.access.qbuilt.com/html/ge...1.html#SplitDB

[riit]

Are you suggesting that we should deploy a front end to say every users home directory instead of a shortcut to one central front end. Would the link work if we did this??

thanks for comments

[RuralGuy]

Are you suggesting that we should deploy a front end to say every users home directory instead of a shortcut to one central front end. Would the link work if we did this??

thanks for comments

That is *exactly* what I am suggesting. You would then launch the local FrontEnd which would link up to the BackEnd tables on the server. There are *free* tools that will assist in deploying updates: http://autofeupdater.com/