How can I load files on a file server that have many different types of files into a table. The files include: Word, Excel Powerpoint, Outlook emails, bmp, gif, tif, jpg, c++, etc. I would like to display the icons of thes objects through an OLE bound control on a form. I can load them individually by hand, but when you have thousands of them to load it would be easier to loop through them and embed them in the table with the class name.
Can anyone help.
I tried streaming them and that does not appear to work because of active x control issue with permissions here.
6  3553 
Like a dog chasing his tail...
Sorry, I was just remembering a time when I had this same issue. I finally got it working the only thing was most everything was 100k or less yet when imported you have to account for the OLE object container itself. MS Access has a 2 gig limit and it doesn't take many OLE objects before you hit this limit. I would strongly suggest that you link to these items then call them as they are needed. If you are insistent about importing them in the manner that you described make sure you back it up before hand so that when you hit the limit and your DB acts like it was run over you won't get to upset.
Let us know what your decision is and I am sure someone will be happy to guide you. I would be glad to help you import the Objects but I haven't imported any OLE objects in years due to the issue I mentioned.
I am using a server as the back end. The problem I find is that when I try to stream the data in it does not work. They have active x security real tight here. I have chunked and appended the data into the table. I would then have to write the data to the users local network drive to link it to an ole object control. The problem is that there are many different formats of blob data and each record could have 1 to 20 blob items.
If there is a better way that works I am all ears. So far this has been a lesson in futility. You would think by now Microsoft would get this problem resolved in a better fashion.
I am using a server as the back end.
Are you referring to SQL Server as a database back end and your using MS Access as a front end?
Are you referring to SQL Server as a database back end and your using MS Access as a front end?
No I am using a Sybase back end.
This is where things get sticky, I have never used Sybase, so I don't know what commands i can or can't use. MS Access has many functions and possible ways of achieving what you want however different back ends can be particular about things. For instance If I try to run a query from Access to update oracle there are some functions that will work in the query that I can't use because Oracle doesn't recognize them.
I will do a little research and see what I an come up with..
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Ryan |
last post by:
Hello,
I have a quick question (I hope). I have a form with a combo box and
a multi-selection list box. The list box is based on a query. Users
can select values from the cmbobox to add to...
|
by: Soul |
last post by:
Hi,
I have a DataGrid which works. But if I load a new table to the DataGrid, it
will still show those old data I load earlier.
private void loadTableA()
{
if ( openFileDialog.ShowDialog()...
|
by: chris |
last post by:
Hi,
I have a table in the database. I have a method which will
return a table with the same structure as the DB one and
with all data I need.
What I want to do is to remove all data in the DB...
|
by: Roger Withnell |
last post by:
I'm using ASP, VBScript and SQL Server.
I'm also using UTF-8 character set and so my codepage is 65001 and SQL
Server datatype nvarchar.
I can insert unicode characters correctly into the...
|
by: MindClass |
last post by:
I load objects from a file (to django framework _but it's a python
question_).
1) Before I used this
from project.I18n.models import *
And to load the object
c1 = Country(name="Afghanistan")...
|
by: quiquef |
last post by:
Hi, I am sending emails to students using PL/SQL. My problem is: if the student wants to unsubscribe from the mailing list. How can I load that into a table using Oracle PL/SQL.
|
by: jackiepajo |
last post by:
I want to delete a picture that i uploaded but icannot delete... by the way im using recordset but i do not how it really works... i just want to have some delete functio... please help..
|
by: munusoni |
last post by:
Hi everyone,
i am using ASP 3.0 to create web pages for a college project and i am
having problems in using recordset object through session object to
pass data to all web pages.Anyone tell me how...
|
by: afromanam |
last post by:
Hello,
Good morning,
I have a question, hope someone can help me.
I have a table with say, 5 columns, each named A,B,C,D,E
The table was imported from Excel, so picture please this:
|
by: manthiralaya |
last post by:
Dear All,
This query is related to MSAccess-Forms-VBA coding to adding new records in to a table using recordset.
For example, I have a table named as 'Table1' with fields F1, F2, F3, F4. In...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
