Re: storing path only to database

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" <noorazlina85@xxxxxxxxx> wrote in message
news:1158626348.428856.308780@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Storing wave files in database
    ... analyse them and store everything in some sort of database. ... You don't store the Wave files in the database. ... ByVal lpOperation As String, _ ... Dim lRet As Long, varTaskID As Variant ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Storing a value for later use in vba or a Macro
    ... One thing I wonder about -- when I split my database and put the tables on ... Dim strCurrentCustomer as String ... do you programmatically store a value from one record to use in another ...
    (microsoft.public.access.gettingstarted)
  • Re: Storing images in postgreSQL (with PHP)
    ... > I am wanting to learn how to store images in a postgreSQL database. ... Some code to load a picture might be: ...
    (comp.lang.php)
  • Re: storing path only to database
    ... is about 5gb..the type of file that i have to store is images ... cannot store all the images because of the limitation...now...i want to ... Dim MyFolder As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: Image problem
    ... This sounds like one of the symptoms of hitting the database size limit? ... Using Photo Editor to store JPEGs causes a huge overhead, since it stores each image uncompressed, then ... Either store the images externally as files, or as blobs if you want them in the database. ...
    (microsoft.public.access.tablesdbdesign)