Re: Access/Comcast/Digital Conversion
- From: sweeneysmsm <sweeneysmsm@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 1 Jul 2009 14:35:01 -0700
Update:
Thank you all for all suggestions.
I did use the Shift-Key trick and that did open the database object window.
Once there I opened a new module and went to Tools/References with the intent
of checking off the box at MSCOMCT2.OCX. Unfortunately this missing reference
was not listed at all. In the earlier error message it said it was to be
found in Windows/System 32. I did a search and found MSCOMCTL.OCX but no
MSCOMCT2.OCX. Since it was supposed to be in Windows System, I thought of
reinstalling SP3. Fortunately, I think, I got sidetracked.
I discovered that I was able to open a different database that I had on my
memory stick. Given that fact, I opted to create a blank Access database and
import the objects from the backup (now that I knew they were there having
been able to see the Database Object Window). This allowed me to resolve the
problem, though admittedly they have data entry work to do to catch up.
I do not understand the problem, but I can live with that since it seems to
be solved at the practical level. I am not 100% sure of that since I think
back to the missing reference, but I am no longer being asked for it. You are
all quite sure that the digital conversion process did not cause the problem,
so do you have any ideas as to what did? I know of 5 places that had trouble
with their internet service at that time. It seems bizarre that in order to
delete a single member record there are a number of steps that have to be
taken to avoid accidents, but somehow with no permissions all of the data and
objects in the original database disappeared with the name of the database
file still intact.
Tony, I read about the Windows update you mentioned and your link to the
“Perform Serial Port Communication”, but only today after I hopefully solved
my problem yesterday. If all is working, is there a need to revisit that? I
opened the source code and had a look at the sample code. I do not understand
what the .bas, .vbp, and .vbw files are. Hopefully you will say I don’t need
to worry about them???
Mary
"Tony Toews [MVP]" wrote:
sweeneysmsm <sweeneysmsm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:.
I have 3 separate clients for whom I have installed an Access database. The
databases have been in use for 5 years in one instance and 3 years for the
other two. They have had no problems until the conversion to Digital TV. All
3 have TV and Internet service from Comcast.
That's not the cause of the problem.
"Database or project contains a missing or broken reference to the file
MSCOMCT2.OCX version 2.0. To make it work properly this must be fixed." I
click on help to see about the fix, but I am told to open an existing module
or create a new one and then go to Tools and checkoff the missing reference.
There was a Windows Update which set the kill bit of various OCXs
almost certainly including that one. For more details poke about on
my blog. See the link in my sig at the bottom of my posting.
Now assuming the above OCX is only used for serial port communications
you can replace it with the VB code as found at the first link at the
See the Serial Port Communications page at my web site.
http://www.granite.ab.ca/access/serialport.htm
This I cannot do because I cannot get to the Module option as it is in the
Database window which does not open.
Try Ctrl+G which should get you to the VBA editor window so you can
take a look at the references.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
- Prev by Date: Re: Date field question
- Next by Date: RE: Date field question
- Previous by thread: Date field question
- Next by thread: Posting Access data to Outlook
- Index(es):
Relevant Pages
|
