[Rockhounds] Database template?

[J Bryan Kramer]

You just pick the right variable type for photos, it's actually better to
store photos out of the db and just store the address of the photos. I'd
have to dig thru the help files on MSDN but it isn't hard to do.

It is very important to thing thru the table structure before building the
db tho. I don't know if you are familiar with normalization but using at
least a couple of levels of normalized tables is a good idea. If you expect
this to be a moderately large db, for smaller db's it really doesn't make a
lot of difference.

I think I only have the current version of access on this computer and I'm
off to the NAS Jacksonville airshow tomorrow or I might be able to set
something up for you easily.


BK

On Fri, Oct 24, 2008 at 17:36, Julie Siebel
<julie at pandemoniumgraphics.com>wrote:

> Well, I'm just trying to figure out a logical sort of format for John. I
> *have* Access (free from Microsoft for a beta test for another app - lol),
> but I haven't worked in it much for the last 5 years, because my main client
> (that's the person kind of client, not the web kind ;) uses SQL Server.
>
> I know that it's possible to display pictures in Access, though I'm not
> really clear of the "how" of it.
>
> John wants to store a picture, with a mineral name, secondary name/habit,
> three locations (site, county, state), date collected, date purchased (for
> purchased minerals), and if it was a trade or whatever, who he got it from.
> And a "notes" field, of course.
>
> He's not looking for chemical formulas or anything - just a pretty generic
> DB. I was hoping someone out there had a template that I could just modify.
>
> Thanks,
>
> Julie
>
>
>
>
> ----- Original Message ----- From: "J Bryan Kramer" <codeburner at gmail.com>
> To: "Rockhounds at drizzle.com: A mailing list for rock and gem collectors" <
> rockhounds at lists.drizzle.com>
> Sent: Friday, October 24, 2008 2:22 PM
> Subject: Re: [Rockhounds] Database template?
>
>
> I don't recall anything detailed about using MS Access there was some
> general talk about databases and someone had written one. I have done some
> Access work(tho it's been awhile), what do you need to know?
>
> BK
>
> On Fri, Oct 24, 2008 at 17:10, Julie Siebel
> <julie at pandemoniumgraphics.com>wrote:
>
>  John was asking me about putting pictures/mineral information in MS Access
>> (we have Access 2003). He swears there was a long discussion about that on
>> the list in the past six months, but I can't find it. (I may be being
>> deceived by the email headers - lol - but I *am* searching.) Anyone
>> remember
>> when that happened?
>>
>> Thanks,
>>
>> Julie
>>
>>
>> --
>> _______________________________________________
>> Rockhounds at drizzle Mailing List
>> Subscription Services:
>> http://lists.drizzle.com/mailman/listinfo/rockhounds
>> List Home Page, with a link to the List Usage Policy:
>> http://www.eclecticlapidary.com/Rockhounds/index.html
>>
>>
>
>
> --
>
>
> "The thunderbolt falls on an inch of ground; but the light of it fills the
> horizon."
>
>                      Ralph Waldo Emerson
>
> J Bryan Krämer
> North Florida, USA
> photos at:
> http://pbase.com/photoburner
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>  text/plain (text body -- kept)
>  text/html
> ---
> --
> _______________________________________________
> Rockhounds at drizzle Mailing List
> Subscription Services:
> http://lists.drizzle.com/mailman/listinfo/rockhounds
> List Home Page, with a link to the List Usage Policy:
> http://www.eclecticlapidary.com/Rockhounds/index.html
>
> --
> _______________________________________________
> Rockhounds at drizzle Mailing List
> Subscription Services:
> http://lists.drizzle.com/mailman/listinfo/rockhounds
> List Home Page, with a link to the List Usage Policy:
> http://www.eclecticlapidary.com/Rockhounds/index.html
>



-- 


"The thunderbolt falls on an inch of ground; but the light of it fills the
horizon."

                       Ralph Waldo Emerson

J Bryan Krämer
North Florida, USA
photos at:
http://pbase.com/photoburner


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---