size of database Access2000...plz...

[leen]

helo...i want to know about something...i think u all know about
this...how much the maximum size for Microsoft Access2000 database??can
i load bitmap files about 38000..which are about 5gig??? plz... i need
an answer...plz... thanks for any help..

[Tom van Stiphout]

Re: size of database Access2000...pl z...

On 12 Sep 2006 18:43:44 -0700, "leen" <noorazlina85@g mail.comwrote:

No.
Keep images in the file system. Much more efficient.

-Tom.

>helo...i want to know about something...i think u all know about
>this...how much the maximum size for Microsoft Access2000 database??can
>i load bitmap files about 38000..which are about 5gig??? plz... i need
>an answer...plz... thanks for any help..

[Wayne Gillespie]

Re: size of database Access2000...pl z...

On 12 Sep 2006 18:43:44 -0700, "leen" <noorazlina85@g mail.comwrote:

>helo...i want to know about something...i think u all know about
>this...how much the maximum size for Microsoft Access2000 database??can
>i load bitmap files about 38000..which are about 5gig??? plz... i need
>an answer...plz... thanks for any help..

The max file size of an A2K db is 2Gb.
Store the images on your HDD and store the path in the db. Use the path to load
the image in an image control.

Wayne Gillespie
Gosford NSW Australia

[leen]

Re: size of database Access2000...pl z...

Can u explain more about the storing the path in the db...How can I
store the path and how to used the path to load the images in an image
control?? because like I said, I have images about 38000 and have size
about 5GB. plz help me......


Wayne Gillespie wrote:

On 12 Sep 2006 18:43:44 -0700, "leen" <noorazlina85@g mail.comwrote:
>

helo...i want to know about something...i think u all know about
this...how much the maximum size for Microsoft Access2000 database??can
i load bitmap files about 38000..which are about 5gig??? plz... i need
an answer...plz... thanks for any help..

>
The max file size of an A2K db is 2Gb.
Store the images on your HDD and store the path in the db. Use the path to load
the image in an image control.
>
Wayne Gillespie
Gosford NSW Australia

[Wayne Gillespie]

Re: size of database Access2000...pl z...

On 12 Sep 2006 22:02:14 -0700, "leen" <noorazlina85@g mail.comwrote:


see this link

http://accdevel.tripod.com/imaging.htm

>Can u explain more about the storing the path in the db...How can I
>store the path and how to used the path to load the images in an image
>control?? because like I said, I have images about 38000 and have size
>about 5GB. plz help me......
>
>
>Wayne Gillespie wrote:

>On 12 Sep 2006 18:43:44 -0700, "leen" <noorazlina85@g mail.comwrote:
>>

>helo...i want to know about something...i think u all know about
>this...how much the maximum size for Microsoft Access2000 database??can
>i load bitmap files about 38000..which are about 5gig??? plz... i need
>an answer...plz... thanks for any help..

>>
>The max file size of an A2K db is 2Gb.
>Store the images on your HDD and store the path in the db. Use the path to load
>the image in an image control.
>>
>Wayne Gillespie
>Gosford NSW Australia

Wayne Gillespie
Gosford NSW Australia

[leen]

Re: size of database Access2000...pl z...

i have seen the link..but what i want is not like that..the example
database in that website is get the images one by one...actually i want
to get all the path of the images in one time,all the 38000...can you
help me??can you figure out how to solve it??
Wayne Gillespie wrote:

On 12 Sep 2006 22:02:14 -0700, "leen" <noorazlina85@g mail.comwrote:
>
>
see this link

http://accdevel.tripod.com/imaging.htm

>
>

Can u explain more about the storing the path in the db...How can I
store the path and how to used the path to load the images in an image
control?? because like I said, I have images about 38000 and have size
about 5GB. plz help me......


Wayne Gillespie wrote:

On 12 Sep 2006 18:43:44 -0700, "leen" <noorazlina85@g mail.comwrote:
>
helo...i want to know about something...i think u all know about
this...how much the maximum size for Microsoft Access2000 database??can
i load bitmap files about 38000..which are about 5gig??? plz... i need
an answer...plz... thanks for any help..
>
The max file size of an A2K db is 2Gb.
Store the images on your HDD and store the path in the db. Use the path to load
the image in an image control.
>
Wayne Gillespie
Gosford NSW Australia

>
Wayne Gillespie
Gosford NSW Australia

[Tom van Stiphout]

Re: size of database Access2000...pl z...

On 13 Sep 2006 00:01:05 -0700, "leen" <noorazlina85@g mail.comwrote:

You're lost bro. Why don't you tell us what you really want to do?

-Tom.

>i have seen the link..but what i want is not like that..the example
>database in that website is get the images one by one...actually i want
>to get all the path of the images in one time,all the 38000...can you
>help me??can you figure out how to solve it??
>Wayne Gillespie wrote:

>On 12 Sep 2006 22:02:14 -0700, "leen" <noorazlina85@g mail.comwrote:
>>
>>
>see this link
>http://accdevel.tripod.com/imaging.htm
>>
>>

>Can u explain more about the storing the path in the db...How can I
>store the path and how to used the path to load the images in an image
>control?? because like I said, I have images about 38000 and have size
>about 5GB. plz help me......
>
>
>Wayne Gillespie wrote:
>On 12 Sep 2006 18:43:44 -0700, "leen" <noorazlina85@g mail.comwrote:
>>
>helo...i want to know about something...i think u all know about
>this...how much the maximum size for Microsoft Access2000 database??can
>i load bitmap files about 38000..which are about 5gig??? plz... i need
>an answer...plz... thanks for any help..
>>
>The max file size of an A2K db is 2Gb.
>Store the images on your HDD and store the path in the db. Use the path to load
>the image in an image control.
>>
>Wayne Gillespie
>Gosford NSW Australia

>>
>Wayne Gillespie
>Gosford NSW Australia

[David W. Fenton]

Re: size of database Access2000...pl z...

"leen" <noorazlina85@g mail.comwrote in
news:1158130865 .911969.34040@i 42g2000cwa.goog legroups.com:

i have seen the link..but what i want is not like that..the
example database in that website is get the images one by
one...actually i want to get all the path of the images in one
time,all the 38000...can you help me??can you figure out how to
solve it??

You're going to load 38,000 images simultaneously? To what end? And
on what computer will it not take several days to load?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[bob]

Re: size of database Access2000...pl z...



I think the idea is to load the filenames into new records in a table, as a batch process.

Something like:

Dim strFile As String
strFile = Dir("c:\somepat h\*.jpg", vbNormal)
Do While strFile <""
DoCmd.GoToRecor d , , acNewRec
[FileName] = strFile
strFile = Dir
Loop


--
_______________ _______________ _______________ __________
The Access Image FAQ

http://www.ammara.com/access_image_faq/

"David W. Fenton" <XXXusenet@dfen ton.com.invalid wrote:

>"leen" <noorazlina85@g mail.comwrote in
>news:115813086 5.911969.34040@ i42g2000cwa.goo glegroups.com:
>

>i have seen the link..but what i want is not like that..the
>example database in that website is get the images one by
>one...actual ly i want to get all the path of the images in one
>time,all the 38000...can you help me??can you figure out how to
>solve it??

>
>You're going to load 38,000 images simultaneously? To what end? And
>on what computer will it not take several days to load?
>
>--
>David W. Fenton http://www.dfenton.com/
>usenet at dfenton dot com http://www.dfenton.com/DFA/

[David W. Fenton]

Re: size of database Access2000...pl z...

"bob" <exponent@hotma il.comwrote in
news:450846ba$1 @news.ammara.co m:

"David W. Fenton" <XXXusenet@dfen ton.com.invalid wrote:

>>"leen" <noorazlina85@g mail.comwrote in
>>news:11581308 65.911969.34040 @i42g2000cwa.go oglegroups.com:
>>

>>i have seen the link..but what i want is not like that..the
>>example database in that website is get the images one by
>>one...actuall y i want to get all the path of the images in one
>>time,all the 38000...can you help me??can you figure out how to
>>solve it??

>>
>>You're going to load 38,000 images simultaneously? To what end?
>>And on what computer will it not take several days to load?

>
I think the idea is to load the filenames into new records in a
table, as a batch process.
>
Something like:
>
Dim strFile As String
strFile = Dir("c:\somepat h\*.jpg", vbNormal)
Do While strFile <""
DoCmd.GoToRecor d , , acNewRec
[FileName] = strFile
strFile = Dir
Loop

Well, we don't actually know, but even that is just a one-time
operation, so there's no reasonable basis for objection.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/