 | | A database question —Jim Hughes
|
| | | Hi: I am currently in the early stages of completely redoing my Lego Technics site and decided it would be cool to put all of my information about technic sets and elements into an Access database (this may not be the best choice but is was free!). (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| | | |
| | | | | Re: A database question —Matthew Miller
|
| | | | | (...) I don't think Todd is using anything non-free -- in either sense of the word 'free'. (Correct me if I'm wrong...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| | | | | |
| | | | | | | Re: A database question —Todd Lehman
|
| | | | | | (...) Jim, if your intention is for other people out on the net to be able to make use of your DB, the best way to publish the tables is in CSV (Comma Separated Values) or tab-delimited ASCII. That way anyone can easily convert it to their own (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| | | | | | |
| | | | | Re: A database question —Todd Lehman
|
| | | | | (...) Since set numbers are not unique, they shouldn't be used as primary keys. So the best solution is to move the set number into a secondary key and introduce a new primary key which is either a function of the set number by tacking on "-1", (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| | | | | |
| | | | | Re: A database question —Steve Bliss
|
| | | | (...) If you go with Access, take the time to write a VBA function to export the data to CSV format. That way, you can share with everyone, and you won't have a export-headache each time you update the database. (...) The classic relational database (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| | | | |
| | | | | | Re: A database question —Larry Pieniazek
|
| | | | | Steve Bliss wrote: < DBA 101, topic: non unique "keys" which really aren't keys.> Yup. AutoNum means no manual thinking about which postfix to attach to the set (and attendent opportunity for error) but also means a number that has no human meaning, (...) (26 years ago, 25-Nov-98, to lugnet.admin.database)
|
| | | | | |
| | | | | | Re: A database question —Huw Millington
|
| | | | Steve Bliss wrote in message <365c1013.5669348@lu...et.com>... (...) Access provides this facility built-in so there's no overhead in keeping it in Access, then creating a query to export the table(s)/fields exactly as required. Huw (26 years ago, 26-Nov-98, to lugnet.admin.database)
|
| | | | |
| | | | | | Re: A database question —Sarah Heacock
|
| | | | (...) But writing a function is MUCH more flexible than the built-in export facility. PLUS you can write it such that you do not have to do anything but press a button to get this file generated, MUCH nicer, IMHO (or perhaps I'm just biased because (...) (26 years ago, 7-Dec-98, to lugnet.admin.database)
|
| | | | |
