form searching 2+ databases

Thread View: comp.databases.ms-access

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by collywobbles Fri, 14 Dec 2001 14:19

#504

Author: collywobbles
Date: Fri, 14 Dec 2001 14:19

6 lines
1525 bytes

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

Re: form searching 2+ databases

#505

Author: 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
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads