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.
It sounds like you didn't get the SQL Server Management Suite for Express. You will want that if you plan on building out view, stored procedures etc... (recommended).
That said - if you're dealing with basic operations (i.e. single table CRUD operations) on small tables, you might care to simply look over using things like datagrids or other such automation feature within .NET, which will largely automate building out those procedures and/or data access features you might need (for simple scenarios they're actually not bad).
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?