473,326 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Re: Insert OLE Object Error 2793

Colin Leahey
Guest
n/a Posts November 12th, 2005
01:40 PM
#3


Re: Insert Ole Object Error 2793
--------------------------------------------------------------------------------

Having looked at the rest of the code in this module I can see the
problem was me using dodgey coding. The idea was the the user never
sees the ole control and just clicks on a button to insert or veiw
objects. So I hid the ole control on the form and didn't let it have
focus.

Private Sub oleBlob_GotFocus()
cmdActivateOLE.SetFocus
End Sub


This was my mistake, the control must have focus in order display the
Insert object dialog.

If anyone comes across this an a MDSN article please could you attach
it as I couldn't find it anywhere and had to work this out for myself.

Colin.
Colin, thank you for your posts on this subject. It helped me to solve a similar problem I was having. I'm designing a form that will let the user select an Excel file to embed. It appears that setting the focus IS the key to this problem, however, you have to make sure you set the ".enabled" property of the OLE object to True before setting the focus. I don't want my users to edit the source file, so I have the OLE object disabled and locked at all times except for when the user wants to look at a different file.

Thanks again!
Specterman
Oct 5 '06 #1
0 1320

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Colin Leahey | last post by:
Hi, I 'm using oleBlob.Action = acOLEInsertObjDlg to insert OLE objects into a database but when this line is executed I get error 2793 'E & S Database can't perform the operation specified in the...
7
by: kosta | last post by:
hello! one of my forms communicates with a database, and is supposed to add a row to a table using an Insert statement... however, I get a 'oledb - syntax error' exception... I have double...
1
by: mraj | last post by:
Can some one help me in locating the list of possible errors that could be thrown out of C#? -- Mohan
1
by: tshad | last post by:
I can't seem to get insert into a DataGrid to work. I am using an example from the net and made changes to work on my computer. The grid comes up fine. The edit boxes in the footer are there. ...
3
by: | last post by:
I'm picking up an 'IMPORTS' error for a simple database insert based on two input entry boxes in my form? It says an 'Imports' statement must preceede any declarations....... is this perahps the...
6
by: SandySears | last post by:
I am trying to use a stored procedure to insert a record using VS 2005, VB and SQL Server Express. The code runs without errors or exceptions, and returns the new identifer in the output...
2
by: Dabbler | last post by:
I'm getting the following error when I try and insert a row using FormView, ObjectDataSource and stored procedure. The form has 40+ columns on it and I'm not sure how to diagnose where the problem...
3
by: mahajanvit | last post by:
Hi one and all I got this problem during my project. So in order to solve this I made a very small application. I am trying to insert using SP and sqldatasource control. I know that while using...
1
by: guzmanp | last post by:
I have this error message: Please anyone knows how I resolve this? An unexpected exception has been detected in native code outside the VM. Unexpected Signal : EXCEPTION_ACCESS_VIOLATION...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.