| | Re: A database question
|
| (...) 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
|
| 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
|
| 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
|
| (...) 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)
| |