Counseling and Disability
Oct 20th, 2006 by Baz L
Maybe getting a job to do a “database” for the Counseling center at Midwestern State University. Currently they have a database “written” in MS Access. All the forms etc. are contained the the Access database and it is accessed (lol) over the network in the office.
My rebuild would be done in C# of course, since that’s what I’m learning right now. I haven’t really decided yet, but I think I’ll just stick with the MS Access database format right now. A SQL Sever 2005 setup would be best, but I don’t think the have the resources available for that (i.e. A dedicated machine to run the server). So I’ll just plop the Database file onto a computer somewhere on the network and let everybody have fun that way.
I’ve done some preliminary tests with the whole thing and it looks promising. It was done over my home network though, and I still can’t get that to work right. The only problem I’ve come across is what happens when two people try to save the same record. The first person gets to save, but the second person is greeted with an error that crashes the program. It will be simple enough to do a quick exception handler to solve that problem and besides that’s the way it should work. I may go a little bit deeper into “locking” a record when it’s being accessed, but I’m not sure.
Basically this job seems quite doable. I hope I do get the contract.
Popularity: 8%
Similar Posts
- None Found
