Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Graphic Data base
- Thread starter shamroy
- Start date
shamroy,
Yes, the key here is to use the OLE data type and fetch/load the data using the GetChunk/AppendChunk methods of a recordset. You may need to split the backend db into multiple .mdbs because Access has a size limit on the .mdb file, I think it's 1 gig on 97 and 2 gig in later versions.
A simpler but less robust option is to just store the path/filenames in a table, but this is less robust because there's no true connection between the record that says FileX is in this folder, and what's actually in that folder.
--jsteph
Yes, the key here is to use the OLE data type and fetch/load the data using the GetChunk/AppendChunk methods of a recordset. You may need to split the backend db into multiple .mdbs because Access has a size limit on the .mdb file, I think it's 1 gig on 97 and 2 gig in later versions.
A simpler but less robust option is to just store the path/filenames in a table, but this is less robust because there's no true connection between the record that says FileX is in this folder, and what's actually in that folder.
--jsteph
- Status
Similar threads
