lonhanner (9/16/2012)
Jeff The size now is 35MB this is over 10 years of data. I do not know for sure. I just took this job because I don.t have work. I lost my job because of plant closing. I worte vb6 programs collecting data on the shop floor. We used Access as a database. I am writting the hard way learn as I go. I have 3 months to do it. Just thought i would give you and others some back ground. I am moving form VB6 to .net 2010 express. Wanting to move away from ACCESS if I can. I also need to know what tools I need for SQL 2008 Express. I have installed on my laptop running windows 7 home premium with 6gig ram but dont know how to use it the only option I have are: Import /export data and Configuration Tools.
I can't help on which .NET tools to use for SQL Server 2008 but, based on what you said above, either Access or SQL 2008 Express should work fine for this for a very long time. I just wanted to make sure you didn't have too many concurrent connections to the DB and that you weren't going to go over 4GB for a long time.
--Jeff Moden
Change is inevitable... Change for the better is not.