umeshkhoje
asked on
Saving OLE Control contents to the Access table ole field.
Hi everybody,
I have designed a table with an OLE field in the Access 97
database.
I wanted to save the Graphics,Video, Picture, Document in this field using VB 6.0.
On the form I am using a OLE control which holds this avi,wav, bmp etc.
Can anyone pl. guide me how to assign this ole to the access field.
Thank you.
UK.
I have designed a table with an OLE field in the Access 97
database.
I wanted to save the Graphics,Video, Picture, Document in this field using VB 6.0.
On the form I am using a OLE control which holds this avi,wav, bmp etc.
Can anyone pl. guide me how to assign this ole to the access field.
Thank you.
UK.
I have one shred of advice, DON'T DO IT!!!! Here is the problem with it. It makes your database huge, and you will take a major performance hit. I have a friend who runs a small toy store. He was storing images of toys in his database. With a few hundred records he maxed out on the size Access will allow databases to be. We did find a solution for his problem, and this is my recommendation. Store the objects as files. Then store the file location in the database. For better versatility, create a share on a machine and store the object files under that share (if in a Novell scenario, have a volume and directory to store the object files). Now store the location of the object in UNC format in the database. Then anyone who has access to that share can access the object, without having to map a network drive, etc. You could also store other information about the object so you can determine how to open it. You will find this solution much more managable and durable. Trust me, you will have trouble storing the objects in the database, we have tried and failed. If you need any more help, let me know.
Later,
Martin
Later,
Martin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Martin,
Thanks for your valuable advice. I gave a similar advice to the person who has designed the database but he was not ready to
believe it. My database size may go to thousands of records. But the number of tables are very few.
I can provide your answer as a support to my statement. This is really helping me. Thanks once again.
Umesh
Thanks for your valuable advice. I gave a similar advice to the person who has designed the database but he was not ready to
believe it. My database size may go to thousands of records. But the number of tables are very few.
I can provide your answer as a support to my statement. This is really helping me. Thanks once again.
Umesh
ASKER