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.
精彩评论