Search results

Hello, Is there an authoritive post somewhere on this board on converting a DB created in Access into a Access Frontend and SQL DB? I am reading up on the caveats of both, and trying to make sure the time I spend developing an Access app for my company isn't wasted when we get a ton of records...

OK, here's my delima (my head is spinning) I have a standard Product table: tblProducts ProductID (PK) ProductName VendorName Description UnitPrice InStock Every Product has many Parts, but one Part may go to many Products I will build this table: tblProductParts PartID (PK) PartName...

I don't get into political debates too much. I'm a huge fan of Jon Stewart's Daily Show, and for those of you that know, that basically means 95% of what goes on in our government is ludacris in my opinion. Yesterday he did a hilarious peace about flag burning, I can't find that clip, but this...

I see now the answer to my own question. The keys in many samples for "OrderDetails" is a composite key made up of OrderID & ProductID. Is this the best way to go? Or would it be better to establish an Auto Number Primary Key for this table alone? Thanks...

What's up everyone, I'm new around here and to db design as well... I'm posting a really rough data model for the first real database I've been putting together. I'm still in the early stages, and the concepts behind db design are still pretty foreign to me, so there are bound to be many...

Whaddup fellas. Aye I'm American, hopefully I'm not subject to a bunch of politics cause of it :p. I'm sure you get plenty of us blokes dropping by huh, this seems a popular place. I don't have much of a portfolio yet (done lots of side work, just never really scrapped samples together) and the...

Just thought this was a good place for an introduction... I work in graphic design, recently migrated from mainly print design to now working in a lot of web design as well (sound familiar?). I have recently undertaken a project to get my feet wet in the world of database design and hope to...