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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2007 - inserting pictures without bloating

Status
Not open for further replies.
Moss100

Moss100

Technical User
Aug 10, 2004
586
GB
Can anyone tell me how to insert (link) pictures into an access 2007 database without making it bloat. I understand that this problem which blighted 2002, 2003 etc has now been resolved in 2007. Is this correct?? Many thanks Mark
 
Sort by date Sort by votes
I can't say for 2007 if that has been fixed. But one way is to only store a link to picture in the table and store the pictures on a drive.

I tried to have patience but it took to long! :) -DW
 
Upvote 0 Downvote
Even in Access 2000 it was possible to store pictures into the database as long as you wrote your own code to serialize the data, rather than use the "automatic" way (as seen in the Northwind database). A search for the GetChunk method in ADO may be the way to start.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
3K
grnzbra
grnzbra
renigar
  • Locked
  • Question
Access VBA Syntax Error 1
Replies
5
Views
2K
Andrzejek
Andrzejek
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
3K
OCM
OCM
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
585
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top