Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am trying to develop an inventory/payroll system for a factory. The information will be stored on a server, Windows Server 2008 R2, and SQL Server 2005. I'm going to store the records on the server, but will develop several front-end client forms in MS Access 2010. The information is currently in an MS Access 2010 database(local), and I'll eventually need to get this data on the server. I currently have a remote desktop access with username and password, however I can't figure out how to get things set up. I have SQL Server 2005 installed on my computer as well. How do I start to make a few test tables, things like that, etc.

Could one of you guys recommend an SQL Server 2005 tutorial? I'm just having a lot of trouble getting started on this project, not really sure what to do. I need to configure the database in such a way that it will allow MS Access 2010 to be the front end.

Thanks for any help I receive, if I need to clarify something please just ask.

share|improve this question

closed as not a real question by Wesley, John Gardeniers, MikeyB, EEAA, Ward Aug 10 '12 at 20:10

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

3  
I'd truly like to know the backstory to this. 1) Inventory/Payroll system, 2) Factory, 3) No one with significant experience in development, database architecture or systems administration is working on a project that touches the most important digital workflows and assets for the company. I haz a sad. =( –  Wesley Apr 26 '12 at 3:43
    
There isn't much story, I'm being hired to develop these systems. I have lots of experience with database design, however I've never done it using these microsoft products. I always programmed them in the past(MySQL mostly, but a few others as well). Will you explain why you downvoted my thread and why it makes you sad? –  Scriptonaut Apr 26 '12 at 3:45
    
I didn't downvote, but likely it was downvoted for being off topic. Tutorial requests and extremely broad questions or questions that don't have a well scoped topic are closed in double-time. –  Wesley Apr 26 '12 at 3:46
    
Where should I post this then? I posted it over at StackOverflow and they directed me here. Tell me why this makes you sad, or why you don't believe me. I posted a similar thread last week and there was a guy who said the same thing. This is disheartening because I have to complete this job for this guy, on top of full time university and a part-time web-developer/admin job. I'm just looking for help man. –  Scriptonaut Apr 26 '12 at 3:51
    
1) Tutorial requests are always off topic for all StackExchange sites. 2) Overly broad topics are off topic for most if not all StackExchange sites. 3) It makes a lot of ServerFaulters frustrated / sad to see huge, important systems being worked on and developed by people whose questions reveal an enormous lack of understanding that jeopardizes the very solvency of the company. 4) We all started somewhere, so props for that. –  Wesley Apr 26 '12 at 4:05
show 3 more comments

1 Answer 1

up vote 3 down vote accepted

Ok, I don't normally do this (post tutorials or hand-hold), but it sounds like you're at least trying to do the right thing by your employer, and I can respect that.

I suggest you start with a free version of SQL Server. Unless your software is wildly popular or you generate massive amounts of payroll data, you will probably never out-grow it.

The free version is called SQL Server 2008 R2 Express.

Now, SQL Server Express ships by default with TCP/IP connections disabled (don't stress too much about what that is, just know you need to enable them). You can find out how to do that here.

Now, what to do about that tutorial? Well, to be honest, a tutorial for SQL Server doesn't really cut it. Databases are very complex, and you need to understand at a bare minimum 3rd normal form and primary keys. Indexes and foriegn keys come a very close second.

There's an eBook from MSDN that might help, but it might be a bit too hardcore for a beginner and has a bit of assumed knowledge. Otherwise, Google might be able to help.


Accessing SQL Server from within Microsoft Access is actually very straight forward. It's even got a very useful scale-out wizard that will even copy your Access database into SQL Server and update all your links and copy all your data. Your first point of call (after installing SQL and enabling TCP/IP connections) might actually be looking at SQL server through the eyes of Access. It's likely to make things a bit less fuzzy.

The point of that is, although I could never condone using an Access back-end database in a work environment (I've just seen too many of those projects outgrow what an Access back-end can handle), if you need to hit the ground running, you can just start in Access and get developing, and then let Access take care of the migration to SQL for you.

share|improve this answer
    
Thank you for the help. I already have the SQL server 2005 Express installed, I'll check if TCP/IP is enabled, if not I'll enable it. The thing is, I actually have a decent amount of experience with databases(I have a CS degree). I just haven't ever used these Microsoft products. The part that is making this difficult is having to use all the business's software, and making sure that everything will remain compatible. I know what 3rd normal form, primary keys, Indexes, and foreign keys are. I want to find the best configuration for a database of my needs. Thanks Again –  Scriptonaut Apr 26 '12 at 4:19
    
May I suggest not starting with SQL 2005 unless you specifically have to? It's already 7 years old. SQL 2008 R2 is 2 years old (damn Microsofts naming schemes) and SQL Server 2012 has just hit the market, which will makes SQL Server 2005 four versions ago. –  Mark Henderson Apr 26 '12 at 4:23
    
I feel like my employer is pretty strict as far as what we use, he is already using the SQL 2005 for other things on the same server. Do you think it's worth converting to 2008? I might be able to convince him if it's going to make a large difference. The database won't be very complex, there will be about 5 tables total, and the vast majority of queries will be uploading barcodes one at a time. I think there are around 50 employees max. I'm just giving you a little more information in case it helps you picture the whole setup. Thanks. –  Scriptonaut Apr 26 '12 at 4:29
    
To go from 2005 to 2008 or 2012 is actually no work at all. You just install the newer version, unmount the database, and mount it in the new version. If you keep your instance name the same, you don't even need to configure your apps. Note: Once you attach a DB to a newer version, you can never attach it to the old version again. SQL Server has compatibility modes which are kept in-tact from the source version that ensures that any depreciated TSQL will still operate. Although 2005 was a mature product, there are three service packs for it. –  Mark Henderson Apr 26 '12 at 4:31
    
Admittedly we only left 2005 last year, and there's not a huge difference for most applications, but the risk of EOL does make me nervous (and was the driving factor behind moving platforms). Once a Microsoft product hits EOL, it doesn't even get critical security updates. –  Mark Henderson Apr 26 '12 at 4:32
show 3 more comments

Not the answer you're looking for? Browse other questions tagged or ask your own question.