storing path only to database

[leen]

helo..i'm az...from kuala lumpur...i would like to ask a question about
access...i have doing a project based on access...i have done it
successfully but now the problem is size of the file...the limit for
access is only 2gb...but the file that i have to put in that database
is about 5gb..the type of file that i have to store is images(bitmap)
about 38000 images...before this,i store all the images to access...but
cannot store all the images because of the limitation...now...i want to
store only the path for the images only...and retrieve the images
later...so that it can reduce the size of the file...the question is
HOW can i do it???anyone can help me??this is the coding that i use to
load all the images to database...i hope this will help you give me
some idea...please help me..if you have any coding for this problem...i
hope you can share with me..

Option Compare Database

Private Sub cmdLoadOLE_Click()
Dim MyFolder As String
Dim MyExt As String
Dim MyPath As String
Dim MyFile As String
Dim strCriteria As String

MyFolder = Me.SearchFolder

' Get the search path.
MyPath = MyFolder & "\" & "*." & [SearchExtension]
' Get the first file in the path containing the file extension.
MyFile = Dir(MyPath, vbNormal)
Do While Len(MyFile) <> 0
[OLEPath] = MyFolder & "\" & MyFile
[OLEFile].Class = [OLEClass]
[OLEFile].OLETypeAllowed = acOLinked
[OLEFile].SourceDoc = [OLEPath]
[OLEFile].Action = acOLECreateLink
' Check for next OLE file in the folder.
MyFile = Dir
' Go to new record on form.
DoCmd.RunCommand acCmdRecordsGoToNew
Loop

End Sub

 

[Arvin Meyer [MVP]]

Do not store the images in the file, rather store them on the hard drive and
store the path to them in the Access database. An example of this is at:

http://www.datastrat.com/Download/Picture2K.zip

Alternatively, you can store images in multiple tables, each one of which is
linked to a front-end database. Because you want some "breathing room" in
each 1 table database, I'd suggest putting no more than 1 GB of images in
each table. That would require 5 back-end databases, each with a single
table.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[leen]

helo Arvin...
thanks for the help..i have look to the link that you suggest...its
really work...that is what i want to do...actually..i hope you can
teach me how to do the database in that
http://www.datastrat.com/Download/Picture2K.zip....i hope i can do it
by myself...can you help me?i hope i dont wasting your time..i have
look to the vba coding in that Picture2K but i dont understand it very
much...so i need your help...i hope you can teach me how to do
it...please....i really appreciate your help...

thank you...

Do not store the images in the file, rather store them on the hard drive and
store the path to them in the Access database. An example of this is at:

http://www.datastrat.com/Download/Picture2K.zip

Alternatively, you can store images in multiple tables, each one of which is
linked to a front-end database. Because you want some "breathing room" in
each 1 table database, I'd suggest putting no more than 1 GB of images in
each table. That would require 5 back-end databases, each with a single
table.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

helo..i'm az...from kuala lumpur...i would like to ask a question about
access...i have doing a project based on access...i have done it
successfully but now the problem is size of the file...the limit for
access is only 2gb...but the file that i have to put in that database
is about 5gb..the type of file that i have to store is images(bitmap)
about 38000 images...before this,i store all the images to access...but
cannot store all the images because of the limitation...now...i want to
store only the path for the images only...and retrieve the images
later...so that it can reduce the size of the file...the question is
HOW can i do it???anyone can help me??this is the coding that i use to
load all the images to database...i hope this will help you give me
some idea...please help me..if you have any coding for this problem...i
hope you can share with me..

Option Compare Database

Private Sub cmdLoadOLE_Click()
Dim MyFolder As String
Dim MyExt As String
Dim MyPath As String
Dim MyFile As String
Dim strCriteria As String

MyFolder = Me.SearchFolder

' Get the search path.
MyPath = MyFolder & "\" & "*." & [SearchExtension]
' Get the first file in the path containing the file extension.
MyFile = Dir(MyPath, vbNormal)
Do While Len(MyFile) <> 0
[OLEPath] = MyFolder & "\" & MyFile
[OLEFile].Class = [OLEClass]
[OLEFile].OLETypeAllowed = acOLinked
[OLEFile].SourceDoc = [OLEPath]
[OLEFile].Action = acOLECreateLink
' Check for next OLE file in the folder.
MyFile = Dir
' Go to new record on form.
DoCmd.RunCommand acCmdRecordsGoToNew
Loop

End Sub

 

[Arvin Meyer [MVP]]

Actually, everything you will need is already there. You can import
everything into your own database, then rearrange the forms and reports to
your requirements.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

helo Arvin...
thanks for the help..i have look to the link that you suggest...its
really work...that is what i want to do...actually..i hope you can
teach me how to do the database in that
http://www.datastrat.com/Download/Picture2K.zip....i hope i can do it
by myself...can you help me?i hope i dont wasting your time..i have
look to the vba coding in that Picture2K but i dont understand it very
much...so i need your help...i hope you can teach me how to do
it...please....i really appreciate your help...

thank you...

Do not store the images in the file, rather store them on the hard drive
and
store the path to them in the Access database. An example of this is at:

http://www.datastrat.com/Download/Picture2K.zip

Alternatively, you can store images in multiple tables, each one of which
is
linked to a front-end database. Because you want some "breathing room" in
each 1 table database, I'd suggest putting no more than 1 GB of images in
each table. That would require 5 back-end databases, each with a single
table.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

helo..i'm az...from kuala lumpur...i would like to ask a question about
access...i have doing a project based on access...i have done it
successfully but now the problem is size of the file...the limit for
access is only 2gb...but the file that i have to put in that database
is about 5gb..the type of file that i have to store is images(bitmap)
about 38000 images...before this,i store all the images to access...but
cannot store all the images because of the limitation...now...i want to
store only the path for the images only...and retrieve the images
later...so that it can reduce the size of the file...the question is
HOW can i do it???anyone can help me??this is the coding that i use to
load all the images to database...i hope this will help you give me
some idea...please help me..if you have any coding for this problem...i
hope you can share with me..

Option Compare Database

Private Sub cmdLoadOLE_Click()
Dim MyFolder As String
Dim MyExt As String
Dim MyPath As String
Dim MyFile As String
Dim strCriteria As String

MyFolder = Me.SearchFolder

' Get the search path.
MyPath = MyFolder & "\" & "*." & [SearchExtension]
' Get the first file in the path containing the file extension.
MyFile = Dir(MyPath, vbNormal)
Do While Len(MyFile) <> 0
[OLEPath] = MyFolder & "\" & MyFile
[OLEFile].Class = [OLEClass]
[OLEFile].OLETypeAllowed = acOLinked
[OLEFile].SourceDoc = [OLEPath]
[OLEFile].Action = acOLECreateLink
' Check for next OLE file in the folder.
MyFile = Dir
' Go to new record on form.
DoCmd.RunCommand acCmdRecordsGoToNew
Loop

End Sub

 

[leen]

yeah...i know...but i want to know how to do it....it just to improve
my knowledge...i hope you dont mind...

tq.....

Actually, everything you will need is already there. You can import
everything into your own database, then rearrange the forms and reports to
your requirements.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

helo Arvin...
thanks for the help..i have look to the link that you suggest...its
really work...that is what i want to do...actually..i hope you can
teach me how to do the database in that
http://www.datastrat.com/Download/Picture2K.zip....i hope i can do it
by myself...can you help me?i hope i dont wasting your time..i have
look to the vba coding in that Picture2K but i dont understand it very
much...so i need your help...i hope you can teach me how to do
it...please....i really appreciate your help...

thank you...

Do not store the images in the file, rather store them on the hard drive
and
store the path to them in the Access database. An example of this is at:

http://www.datastrat.com/Download/Picture2K.zip

Alternatively, you can store images in multiple tables, each one of which
is
linked to a front-end database. Because you want some "breathing room" in
each 1 table database, I'd suggest putting no more than 1 GB of images in
each table. That would require 5 back-end databases, each with a single
table.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

helo..i'm az...from kuala lumpur...i would like to ask a question about
access...i have doing a project based on access...i have done it
successfully but now the problem is size of the file...the limit for
access is only 2gb...but the file that i have to put in that database
is about 5gb..the type of file that i have to store is images(bitmap)
about 38000 images...before this,i store all the images to access...but
cannot store all the images because of the limitation...now...i want to
store only the path for the images only...and retrieve the images
later...so that it can reduce the size of the file...the question is
HOW can i do it???anyone can help me??this is the coding that i use to
load all the images to database...i hope this will help you give me
some idea...please help me..if you have any coding for this problem...i
hope you can share with me..

Option Compare Database

Private Sub cmdLoadOLE_Click()
Dim MyFolder As String
Dim MyExt As String
Dim MyPath As String
Dim MyFile As String
Dim strCriteria As String

MyFolder = Me.SearchFolder

' Get the search path.
MyPath = MyFolder & "\" & "*." & [SearchExtension]
' Get the first file in the path containing the file extension.
MyFile = Dir(MyPath, vbNormal)
Do While Len(MyFile) <> 0
[OLEPath] = MyFolder & "\" & MyFile
[OLEFile].Class = [OLEClass]
[OLEFile].OLETypeAllowed = acOLinked
[OLEFile].SourceDoc = [OLEPath]
[OLEFile].Action = acOLECreateLink
' Check for next OLE file in the folder.
MyFile = Dir
' Go to new record on form.
DoCmd.RunCommand acCmdRecordsGoToNew
Loop

End Sub

 

[leen]

helo Arvin...
in Picture2K, you did not store the images to the table..you just store
the path of the file only..my question is...how you do that?whats
coding show this process..can you guide me for this process..actually,
i have look to your coding in vba in that Picture2K but i dont where is
the part you store the path only and how you call the images to be
displayed..can you help me...plz...i really need a help...

 

[Arvin Meyer [MVP]]

Most of the code that does it is in the modPath_File standard module
functions called from the OK button on the CreateTable form.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com