I am in need of assisstance, I dabble in database programming and learning more about databases (programmatical, and design aspects) in my free time. I am a 100% amatuer, if there could be a classification below amatuer then that would be me.
With that being said, I have a single table that contains a list of SKUs and all the details that I want in my program in this table. It has about 11,000 records (not sure if this is relevant knowledge or not).
I also have a query, a form and a subform. The form has some simple macro's behind it, and the query has a little SQL behind it.
In a nutshell, the query uses the form's controls to query the table, and the subform pulls the query into datasheet view.
The user will need to change 3 fields and only 3 fields of the 9 fields in the table, they can obviously do this through the subform. What I don't want is for them changing anything else. I am unsure how to go about doing this though. The computers that will be using this are shared among many people so logins and passwords are out of the question.
I personally was going to figure out how to keep the table stored on one of our servers, and keep the rest of it stored on each computer in the back where it will be used. However something that I don't know what the effect will be is that, the server I believe has office 2007 on it, while the computers that will use this have 2003. It is in mdb format...finally (I built the database in 2010, because I was told by the IT personnel that the target computers had 2007)
I realize in a perfect world that VB could be used to make a front end, but I have no idea how to open up or work with a database in VB.
Any suggestions would be helpful, I'll even take rude comments if they have some informative information in them!
Also the people who will be using this application will be uneducated, so the more user friendly I can get it the better. (This is just an afterthought)
Thanks for your time.
Ben