Access would work fine if you get the record locking right. If it is just a single large table then you could simply export it into SharePoint and then it handles the record locking. We have a lot of clients using SharePoint for shared phone call logs and job allocation.
Mike -----Original Message----- From: Kurt Buff [mailto:[email protected]] Sent: 23 June 2010 20:43 To: NT System Admin Issues Subject: Re: Shared spreadsheet freezes Access is the debbil - I recommend against it. Don't know sharepoint, so can't say. I suggest an IIS front end to SQL Express, or something similar. Kurt On Wed, Jun 23, 2010 at 11:34, Cameron Cooper <[email protected]> wrote: > We have a research dept. that uses an Excel spreadsheet to enter in > which orders are assigned to different researchers. Currently the > spreadsheet is shared between 6 people (which all have it open and > make changes to it throughout the day) and is stored on a network > drive. The issue is throughout the day the spreadsheet grows in file > size, which in turn causes it to freeze or crash. > > > > Without using google apps or office apps online, is there another > method that we can use (ie Access, sharepoint)? > > > > _____________________________ > > Cameron Cooper > > Network Administrator | CompTIA A+ Certified > > Aurico Reports, Inc > > Phone: 847-890-4021 | Fax: 847-255-1896 > > [email protected] | www.aurico.com > > > > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
