View Single Post
  #10   Spotlight this post!  
Unread 17-03-2004, 21:00
Greg's Avatar
Greg Greg is offline
Registered User
FRC #1075 (Sinclair Sprockets)
Team Role: College Student
 
Join Date: Nov 2002
Rookie Year: 2003
Location: Whitby, Ontario, Canada
Posts: 108
Greg is on a distinguished road
Send a message via ICQ to Greg Send a message via MSN to Greg
Re: Access Database help...

This is an interesting problem I have done quite a lot of VB, so I wrote the code that shows an image of the robot on the form in an Access DB. Since you probably use a form for data entry/display, this should be what you want.

The only thing I wanted to point out is that the images are not actually stored in the database. The code only stores the path to the images. So they still have to sit on the hard drive in some folder. Why? Because Access is very inefficient at storing images and has a file size limit of around 1 GB. And this limit is reached very quickly with just a hundred JPEGs stored as OLE objects.

You can grab the example database off our web server here: http://www.sinclairsprockets.com/imagedb.zip. I hope you find it useful. And if you rename the database table you'll need to edit the code.