Print Page | Close Window

Snapshot.mdb (beginner)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=267
Printed Date: 28 Mar 2024 at 4:32pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Snapshot.mdb (beginner)
Posted By: Roger Carlson
Subject: Snapshot.mdb (beginner)
Date Posted: 22 Jul 2008 at 10:34pm

Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 

Snapshot.mdb

It is usually preferable NOT to store OLE objects like snapshots in the table itself. It causes massive database bloat. The usual solution is to store the snapshots as files on the hard drive and store the file name in the table. This sample demonstrates how to to this.

1) Store the snaptshots in the same directory as the database. 2) Store the appropriate snapshot name in the table. 3) Programmatically set the .Snapshotpath property of an Snapshot Active X control to the appropriate file in the On Current event of the form.

Download
Access 2000 (41 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/Snapshot2k.zip - uploads/5/Snapshot2k.zip


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net