Error message upon opening database from other computer in network

[Guest]

I am trying to open the database from another computer in our offices
network, to make sure others may use it. But the newest computer is having a
problem with it.

The message reads: Your database or project contains a missing or broken
reference to the file 'Mscomet2.ocx' version 2.0

To ensure that your database or project works properly, you must fix this
reference. End of Message.

Is it because of a newer access program on the computer or is it because of
the network. All other computers can use it with out any problems. What can I
do?

Thanks,
Dustin

 

[George Hepworth]

Access is telling you that it can't find that particular file
('Mscomet2.ocx' ) on the computer from which you are trying to start the
database. Unfortunately, this is not uncommon in many offices, particularly
those where different machines were installed at different times with
different versions of applications. It may be that this particular ocx is
missing from the second machine, or that it is in a different folder. In any
event Access can't find it.

You can try to resolve this by opening any code module in the database and
clicking Tools--> References from the Menu Bar. This will open a dialog box
and display all of the references.

Look for this one, 'Mscomet2.ocx' , which should be checked and flagged as
"Missing". Uncheck it, then close the references window.

Now, click on Debug-->Compile [your database] on the Menu Bar. If the code
compiles, you do not need that reference and you should be good to go.

If the code does not compile, then you'll need to locate the missing
reference and add it.

You'll have to use the browse function in the References Dialog to find it.

HTH

 

[George Hepworth]

IS it possible that 'Mscomet2.ocx' is a typo and that the missing reference
is Mscomct2.ocx? It is used for things like Animation, UpDown, MonthView,
DTPicker, and FlatScrollBar controls and would seem to be more likely the
one that is missing on this PC?

 

[Guest]

Does this need to be done on the machine that will carry the database? Or can
I take it off the main computer and change it on mine?

Thanks
Dustin

Access is telling you that it can't find that particular file
('Mscomet2.ocx' ) on the computer from which you are trying to start the
database. Unfortunately, this is not uncommon in many offices, particularly
those where different machines were installed at different times with
different versions of applications. It may be that this particular ocx is
missing from the second machine, or that it is in a different folder. In any
event Access can't find it.

You can try to resolve this by opening any code module in the database and
clicking Tools--> References from the Menu Bar. This will open a dialog box
and display all of the references.

Look for this one, 'Mscomet2.ocx' , which should be checked and flagged as
"Missing". Uncheck it, then close the references window.

Now, click on Debug-->Compile [your database] on the Menu Bar. If the code
compiles, you do not need that reference and you should be good to go.

If the code does not compile, then you'll need to locate the missing
reference and add it.

You'll have to use the browse function in the References Dialog to find it.

HTH

--
George Hepworth
2007 Access MVP

I am trying to open the database from another computer in our offices
network, to make sure others may use it. But the newest computer is having
a
problem with it.

The message reads: Your database or project contains a missing or broken
reference to the file 'Mscomet2.ocx' version 2.0

To ensure that your database or project works properly, you must fix this
reference. End of Message.

Is it because of a newer access program on the computer or is it because
of
the network. All other computers can use it with out any problems. What
can I
do?

Thanks,
Dustin

 

[George Hepworth]

Well, it's missing on the machine that gives you the error, therefore, you
must fix it on the machine that is giving you the error.

As I posted later, are you sure the missing ocx is not mscomct2.ocx, which
is more common?

--
George Hepworth
2007 Access MVP

Does this need to be done on the machine that will carry the database? Or
can
I take it off the main computer and change it on mine?

Thanks
Dustin

Access is telling you that it can't find that particular file
('Mscomet2.ocx' ) on the computer from which you are trying to start the
database. Unfortunately, this is not uncommon in many offices,
particularly
those where different machines were installed at different times with
different versions of applications. It may be that this particular ocx is
missing from the second machine, or that it is in a different folder. In
any
event Access can't find it.

You can try to resolve this by opening any code module in the database
and
clicking Tools--> References from the Menu Bar. This will open a dialog
box
and display all of the references.

Look for this one, 'Mscomet2.ocx' , which should be checked and flagged
as
"Missing". Uncheck it, then close the references window.

Now, click on Debug-->Compile [your database] on the Menu Bar. If the
code
compiles, you do not need that reference and you should be good to go.

If the code does not compile, then you'll need to locate the missing
reference and add it.

You'll have to use the browse function in the References Dialog to find
it.

HTH

--
George Hepworth
2007 Access MVP

I am trying to open the database from another computer in our offices
network, to make sure others may use it. But the newest computer is
having
a
problem with it.

The message reads: Your database or project contains a missing or
broken
reference to the file 'Mscomet2.ocx' version 2.0

To ensure that your database or project works properly, you must fix
this
reference. End of Message.

Is it because of a newer access program on the computer or is it
because
of
the network. All other computers can use it with out any problems. What
can I
do?

Thanks,
Dustin

 

[Guest]

Yeah, thats the one. Do I do anything different than what you told me before?

Well, it's missing on the machine that gives you the error, therefore, you
must fix it on the machine that is giving you the error.

As I posted later, are you sure the missing ocx is not mscomct2.ocx, which
is more common?

--
George Hepworth
2007 Access MVP

Does this need to be done on the machine that will carry the database? Or
can
I take it off the main computer and change it on mine?

Thanks
Dustin

Access is telling you that it can't find that particular file
('Mscomet2.ocx' ) on the computer from which you are trying to start the
database. Unfortunately, this is not uncommon in many offices,
particularly
those where different machines were installed at different times with
different versions of applications. It may be that this particular ocx is
missing from the second machine, or that it is in a different folder. In
any
event Access can't find it.

You can try to resolve this by opening any code module in the database
and
clicking Tools--> References from the Menu Bar. This will open a dialog
box
and display all of the references.

Look for this one, 'Mscomet2.ocx' , which should be checked and flagged
as
"Missing". Uncheck it, then close the references window.

Now, click on Debug-->Compile [your database] on the Menu Bar. If the
code
compiles, you do not need that reference and you should be good to go.

If the code does not compile, then you'll need to locate the missing
reference and add it.

You'll have to use the browse function in the References Dialog to find
it.

HTH

--
George Hepworth
2007 Access MVP


I am trying to open the database from another computer in our offices
network, to make sure others may use it. But the newest computer is
having
a
problem with it.

The message reads: Your database or project contains a missing or
broken
reference to the file 'Mscomet2.ocx' version 2.0

To ensure that your database or project works properly, you must fix
this
reference. End of Message.

Is it because of a newer access program on the computer or is it
because
of
the network. All other computers can use it with out any problems. What
can I
do?

Thanks,
Dustin

 

[George Hepworth]

Which one is the one? mscomct2.ocx?

Nope same thing, just that mscomct2.ocx is more common and therefore more
likely to be found lurking on that machine somewhere. If you can not find
it, you can download and install it from MS.
http://support.microsoft.com/kb/297381



--
George Hepworth
2007 Access MVP

Yeah, thats the one. Do I do anything different than what you told me
before?

Well, it's missing on the machine that gives you the error, therefore,
you
must fix it on the machine that is giving you the error.

As I posted later, are you sure the missing ocx is not mscomct2.ocx,
which
is more common?

--
George Hepworth
2007 Access MVP

Does this need to be done on the machine that will carry the database?
Or
can
I take it off the main computer and change it on mine?

Thanks
Dustin

:

Access is telling you that it can't find that particular file
('Mscomet2.ocx' ) on the computer from which you are trying to start
the
database. Unfortunately, this is not uncommon in many offices,
particularly
those where different machines were installed at different times with
different versions of applications. It may be that this particular ocx
is
missing from the second machine, or that it is in a different folder.
In
any
event Access can't find it.

You can try to resolve this by opening any code module in the database
and
clicking Tools--> References from the Menu Bar. This will open a
dialog
box
and display all of the references.

Look for this one, 'Mscomet2.ocx' , which should be checked and
flagged
as
"Missing". Uncheck it, then close the references window.

Now, click on Debug-->Compile [your database] on the Menu Bar. If the
code
compiles, you do not need that reference and you should be good to go.

If the code does not compile, then you'll need to locate the missing
reference and add it.

You'll have to use the browse function in the References Dialog to
find
it.

HTH

--
George Hepworth
2007 Access MVP


I am trying to open the database from another computer in our offices
network, to make sure others may use it. But the newest computer is
having
a
problem with it.

The message reads: Your database or project contains a missing or
broken
reference to the file 'Mscomet2.ocx' version 2.0

To ensure that your database or project works properly, you must fix
this
reference. End of Message.

Is it because of a newer access program on the computer or is it
because
of
the network. All other computers can use it with out any problems.
What
can I
do?

Thanks,
Dustin