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.. 9 1390
On 12 Sep 2006 18:43:44 -0700, "leen" <no**********@gmail.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..
On 12 Sep 2006 18:43:44 -0700, "leen" <no**********@gmail.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
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" <no**********@gmail.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
On 12 Sep 2006 22:02:14 -0700, "leen" <no**********@gmail.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" <no**********@gmail.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
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" <no**********@gmail.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" <no**********@gmail.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
On 13 Sep 2006 00:01:05 -0700, "leen" <no**********@gmail.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" <no**********@gmail.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" <no**********@gmail.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" <no**********@gmail.comwrote in
news:11*********************@i42g2000cwa.googlegro ups.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/
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:\somepath\*.jpg", vbNormal)
Do While strFile <""
DoCmd.GoToRecord , , acNewRec
[FileName] = strFile
strFile = Dir
Loop
--
__________________________________________________ _____
The Access Image FAQ http://www.ammara.com/access_image_faq/
"David W. Fenton" <XX*******@dfenton.com.invalidwrote:
>"leen" <no**********@gmail.comwrote in news:11*********************@i42g2000cwa.googlegr oups.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" <ex******@hotmail.comwrote in
news:45********@news.ammara.com:
"David W. Fenton" <XX*******@dfenton.com.invalidwrote:
>>"leen" <no**********@gmail.comwrote in news:11*********************@i42g2000cwa.googleg roups.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?
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:\somepath\*.jpg", vbNormal)
Do While strFile <""
DoCmd.GoToRecord , , 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/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: aa |
last post by:
I have beem recommended to use the Nz() function in the ORDER BY part of an
Access2000 stored query.
The query runs correcly from within Access2000
Yet when ran from ASP, it causes an error:
...
|
by: owen |
last post by:
I want to use an Access 2000 database to power my .ASP web pages. Typical
example would be somebody filling in a form on the web page and saving it to
the database when they click a 'Submit'...
|
by: tina1 |
last post by:
I am very new with Microsoft Databases, so know very little. This may be a
dumb question, but need help. Here's my question - I emailed myself a
database from work to home to do some of my work at...
|
by: IkyL234 |
last post by:
I'm using Access2000.
I have just designed a database which seems to be operating very slow on a
network. There are currently only a few records in it.
Should I be compacting it now before it gets...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |