Re: form searching 2+ databases

Article View: comp.databases.ms-access

Article #505

Back to comp.databases.ms-access Previous Next

#505

From: Turtle
Date: Sat, 15 Dec 2001 02:35

24 lines
2123 bytes

It is generally a pretty bad idea to put images directly into Access
databases.
Since the image is just a bitmap representation of the graphic, I'm at a
loss to know what you're going to "search" in this binary data.

I'd suggest that you store data ABOUT the images in the database.  Data for
several thousand images will fit quite comfortably in a single MDB file,
which can hold up to 2 GB of data.
One of the pieces of information you store for each image might be the
filename (which can include the path) for the actual image file.

HTH
    - Turtle

"collywobbles" <collywobbles@e30bmw.8m.com> wrote in message
news:CTnS7.3048$_3.11782@news.iol.ie...
> i need to design a database which will contain thousands of images.
> Due to size restrictions with access i reckon i need to make about 3 or 4
> databases and i want to have a form searching all of them at once.
> is it possible and if so how?
> if the answer is no what should i do?
> Thanks
>
>

Technical Details

Message-ID: <9ved2q$irn$1@slb5.atl.mindspring.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!logbridge.uoregon.edu!newsfeed.direct.ca!look.ca!newsfeed1.earthlink.net!newsfeed2.earthlink.net!newsfeed.earthlink.net!news.mindspring.net!not-for-mail

References: <CTnS7.3048$_3.11782@news.iol.ie>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,3201b2cbff283466
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 101bdd,3201b2cbff283466
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 10f31b,3201b2cbff283466
X-Google-Attributes: gid10f31b,public
X-Google-ArrivalTime: 2001-12-14 18:37:03 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!logbridge.uoregon.edu!newsfeed.direct.ca!look.ca!newsfeed1.earthlink.net!newsfeed2.earthlink.net!newsfeed.earthlink.net!news.mindspring.net!not-for-mail
From: "Turtle" <macdermott@mindspring.com>
Newsgroups: comp.databases.ms-access,free.database.access,microsoft.public.access.forms
Subject: Re: form searching 2+ databases
Date: Fri, 14 Dec 2001 21:35:19 -0500
Organization: MindSpring Enterprises
Lines: 26
Message-ID: <9ved2q$irn$1@slb5.atl.mindspring.net>
References: <CTnS7.3048$_3.11782@news.iol.ie>
NNTP-Posting-Host: d1.56.0c.37
X-Server-Date: 15 Dec 2001 02:38:18 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200

Reply to Parent Message