What should be done with an Access database that is getting too large?

It may be vague and hopefully the right site to ask, but I am not really privvy to Access and programming. I have a manager that created an Access database and some front end stuff for transportation related tracking and employee data info. It has grown to a 2 gig filesize, and now multiple users accessing. From 开发者_Python百科what I've read this should be imported and used from a SQL server of some sort. Is there a best practice for what type of server software to use, or just moving out of the Acccess limitations? Again sorry for the naivety...

---

You can and should migrate the data to SQL Server.

Here is how: http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx

---

Or if practical, you could simply export and delete the old data, especially if you're not using it anymore. If you have a couple years worth of data, you probably can delete the early years of activity and recover some space.