PC Review


Reply
Thread Tools Rate Thread

Can I insert and retrieve certain objects in access 2007?

 
 
=?Utf-8?B?T3JtYW4=?=
Guest
Posts: n/a
 
      24th Mar 2007
I have a fairly new HP atholon based computer - bought in
January - running Windows Media Center. I also have
Windows Office Professional which I downloaded and
registered - permanently - as 1 of the "gimmees" from
going to the Vista/Office 2007 launch back in February.
I have certainly made a number of significant software
changes and setting changes since then. Including 1)
upgrading from the "as delivered" IE6 to IE7 because IE6
froze frequently; 2) installing Firefox 2.whatever.

I am aware that there may be differences between the
"Gimmee" version of Office 2007 - at least the licensing
seems to be different since the "gimmee" version can be
installed only on 1 computer. And I suppose that could be the source of my
problem. I will also admit that for a few days I did not have
the problem I am about to describe but although I try to
keep careful notes about changes, I cannot see anything
that would suggest a source of the problem.

My problem: it used to that one could create an Access
table containing an ole object as a field. Then, click on
the field, select insert object,then choose created from
file, and embed (not link) a piece of HTML. (IE7 is the default
handler, not Firefox.) Similarly, if there was already
an ole object embedded existence, one could click on the field
in the Access record open it. Doesn't work that way in
Access 2007 anymore. I have an access db I converted from
Access 2000. Everytime I try to add an object or even to
open an exsiting one, the application stalls - it goes no
place but consumes no cylces so it is not in a loop.
I then vave to go into task manager (which shows it as
non-responding) kill the app - it won't die, so I get to
report the problem to the Mothership. As I have done
dozens of times. And there is no resolution.

So I created a brand new Access database from scratch.
One simple table. It behaves lik my my
converted db. I can insert certain objects(.DOCX and
..xlsx and .rtf from wordpad ) but fails as described for .txt .html and .mht.

Any thoughts about fixing the problem, working around it
or salvaging the data I have accumulated?


 
Reply With Quote
 
 
 
 
Saracen
Guest
Posts: n/a
 
      26th Mar 2007

"Orman" <(E-Mail Removed)> wrote in message
news:8605DD9B-B6CC-4A52-91B5-(E-Mail Removed)...
>I have a fairly new HP atholon based computer - bought in
> January - running Windows Media Center. I also have
> Windows Office Professional which I downloaded and
> registered - permanently - as 1 of the "gimmees" from
> going to the Vista/Office 2007 launch back in February.
> I have certainly made a number of significant software
> changes and setting changes since then. Including 1)
> upgrading from the "as delivered" IE6 to IE7 because IE6
> froze frequently; 2) installing Firefox 2.whatever.
>
> I am aware that there may be differences between the
> "Gimmee" version of Office 2007 - at least the licensing
> seems to be different since the "gimmee" version can be
> installed only on 1 computer. And I suppose that could be the source of my
> problem. I will also admit that for a few days I did not have
> the problem I am about to describe but although I try to
> keep careful notes about changes, I cannot see anything
> that would suggest a source of the problem.
>
> My problem: it used to that one could create an Access
> table containing an ole object as a field. Then, click on
> the field, select insert object,then choose created from
> file, and embed (not link) a piece of HTML. (IE7 is the default
> handler, not Firefox.) Similarly, if there was already
> an ole object embedded existence, one could click on the field
> in the Access record open it. Doesn't work that way in
> Access 2007 anymore. I have an access db I converted from
> Access 2000. Everytime I try to add an object or even to
> open an exsiting one, the application stalls - it goes no
> place but consumes no cylces so it is not in a loop.
> I then vave to go into task manager (which shows it as
> non-responding) kill the app - it won't die, so I get to
> report the problem to the Mothership. As I have done
> dozens of times. And there is no resolution.
>
> So I created a brand new Access database from scratch.
> One simple table. It behaves lik my my
> converted db. I can insert certain objects(.DOCX and
> .xlsx and .rtf from wordpad ) but fails as described for .txt .html and
> .mht.
>
> Any thoughts about fixing the problem, working around it
> or salvaging the data I have accumulated?
>
>



 
Reply With Quote
 
=?Utf-8?B?T3JtYW4=?=
Guest
Posts: n/a
 
      28th Mar 2007

Apparently the answer is no. If one resets the IE7 security settings to the
defaults, the problem goes away. Instead, one gets a message saying "The
operation on the OLD object failed. The OLE server may not be registered."

So I guess anybody who wants to store HTML pages in Access is SOL.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
I cannot insert objects in MS Word 2007 Teresa Microsoft Word Document Management 6 1st Oct 2009 10:29 PM
How to insert form objects (checkboxes, radio buttons) into Word 2007? Michael Herchel Microsoft Word New Users 2 18th May 2007 05:21 PM
insert new record in Access dbase AND retrieve autonumber loreille Microsoft ASP .NET 1 28th Oct 2004 07:57 PM
re:insert new record in Access dbase AND retrieve autonumber loreille Microsoft ASP .NET 0 28th Oct 2004 03:55 PM
insert record in Ms Access database AND retrieve the autonumber (ID) nicholas Microsoft ASP .NET 5 20th Oct 2004 05:02 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:45 PM.