Options in Tools is not available

  • Thread starter Thread starter Jan Il
  • Start date Start date
J

Jan Il

Hi all :-) Win2K - Access 2002XP

I have just installed my Office 2002 XP onto a new hard drive, and all sees
to do alright, except that I can not set my Options in Access, as the
Options on the Tools bar is grayed out.

I would truly appreciate any suggestions as to why this may be happening,
and perhaps some way of clearing it so that I can set my new files
locations.

Jan :)
Smiles are meant to be shared,
that's why they're so contagious.
 
do you have new or exiting database open while you look for option on the
tool bar. becase if you are trying to find options without having database
open, then option on tool bar will be grayed out. let me know if this work.
Kanwarjit
 
Hi ruby :-)
do you have new or exiting database open while you look for option on
the tool bar. becase if you are trying to find options without
having database open, then option on tool bar will be grayed out.
let me know if this work. Kanwarjit
Click to expand...

Yes...that appears to be the problem. I opened an old DB and it now appears
to work ok. However, when I open the DB using the shortcut, one which I
created fresh with the new location in Win2000, I am getting the following
error message:

Cannot find the file ""C:\Documents and Settings\jan\My
Documents\Access\Jan's Checking Registry\Jan's Checking.mdb"

The path in the shortcut is as follows:

"C:\Documents and Settings\jan\My Documents\Access\Jan's Checking
Registry\Jan's Checking.mdb"....which is the correct location of the file. I
even did a manual Find Target, and right clicked the file and did a Create
Shortcut, and it still gives me this error. But, it goes on to open the
file ok.

Although it opens the file, I tarry to ignore the problem, as I am not sure
at what point I may wind up with a corrupted file. While I have everything
backed up twice, I don't like having such situations going on.

I have tried to look up information on this error but I have not found much
that applies to the current problem. I'm truly sorry to impose on your time
any further, but, if you have any suggestions on this issue, I'd be very
grateful.

Thank you for your time and assistance, I truly appreciate it. :-)

Jan :)
 
Hi Jan! How are you? Hope things are ok for you, and you are settled...

Jan, I notice a small difference between the error message listing of the
path and your description of the path. It could just be a typing error, but
there are two double-quotes at the beginning of the path in the error
message... Could you be having a problem with quotes?


Fred Boer
 
Fred said:
Hi Jan! How are you? Hope things are ok for you, and you are
settled...

Jan, I notice a small difference between the error message listing of
the path and your description of the path. It could just be a typing
error, but there are two double-quotes at the beginning of the path
in the error message... Could you be having a problem with quotes?


Fred Boer
Click to expand...
 
Hi Fred! :-)
Hi Jan! How are you? Hope things are ok for you, and you are
settled...
Click to expand...

I'm very well, thank you! I've finally received delivery all my stuff, so
now I'm trying to find a place for it all... :-))
Jan, I notice a small difference between the error message listing of
the path and your description of the path. It could just be a typing
error, but there are two double-quotes at the beginning of the path
in the error message... Could you be having a problem with quotes?
Click to expand...

Yes...that is a typo...sorry for that. After looking at this stuff all day,
my eyes are going blotto on me. Thank you for pointing that out. <g>

It is just confusing as to why it won't recognize the accurate file path
when I first click the shoretcut, yet will go ahead and open the file
correctly. ???

Thank you for your time and help, I really appreciate it. :-)

Jan :)
 
Hi Fred :-)
:
I tried a few scenarios last night, but sorry, Jan, I don't have a
clue! :(
Click to expand...

I am not sure now this may be an Access problem. I have recreated the
shortcuts several times, and I still get the same error message. But, if I
open a new Access window, and then Open one of the existing DB's, it opens
just fine, no error message of any kind. Thus, it appears to be a 'thing'
with the shortcuts, obviously, an issue with my new Win2000. When I open
the copy of the same DB on the WinME drive, I don't get any error message.
Therefore, I don't believe it is an issue with either Access or the DB's
themselves, but, with Win2000. It just doesn't want to see it, or
something...??? The shortcuts for Word, Excel and PowerPoint of the same
Office 2002 Xp all work fine, no errors. It's just the Access one. Oh
well.....more new things to learn... ;o)

Thanks for checking, and for your time to help. I really appreciate it. :-)

Jan :)
Smiles are meant to be shared,
that's why they're so contagious.
 
Hi Joan :-)

The extra double quote was a typo on my part, the actual error read:

Cannot find the file 'C:\Documents and Settings\jan\My
Documents\Access\Jan's Checking Registry\Jan's Checking.mdb' (or one of its
components). Make sure the path and filename are correct and that all
required libraries are available. I think the single quite is the message
indicating the actual error infomation, as it is not like that in the
shortcut patj information.

This is the exact wording of the path of the Target as I've copied and
pasted it here, after creating the new shortcut to make sure of the exact
wording of the path:

"C:\Documents and Settings\jan\My Documents\Access\Jan's Checking
Registry\Jan's Checking.mdb"

I did a right click on the app and did a Create Shortcut, then placed it on
the Desktop. This to make sure the path was created and worded properly.
But, it still gives me the error message. This happens with all 3 of the
ones that have a shortcut. I also have a drive with WinME, in which the
original apps were created with Office 2002 XP as well. I just copied my
data files over to the new drive once Win2000 and Office 2002 XP were
installed. Is there perhaps something I need to do in the transition of the
app from WinME to Win2000 that I may not be aware of? I just installed the
new drive and Win2000 2 days ago, so I'm afraid I'm not quite up on the
details of the new OS yet. :-)

It says it can not find the file or a component. What component might it
not be able to find that would fire the error message, and yet still allow
the file to open? I have checked the app to be sure the required References
are there, and nothing has changed. Is there a library or reference issue I
should address with the transfer of the data to the new OS?

Thank you very much for your time and assistance, Joan, I truly appreciate
it. I'm just now sure which program is the one causing the problem. :-)

Jan :)
Smiles are meant to be shared,
that's why they're so contagious.
 
Jan said:
Hi Joan :-)

The extra double quote was a typo on my part, the actual error read:
Click to expand...

No I mean the single quote ie in Jan's Checking Registry and Jan's
Checking.mdb
 
Hi Joan :-)
No I mean the single quote ie in Jan's Checking Registry and Jan's
Checking.mdb
Click to expand...

I renamed the DB leaving out the quote in the Jan's and created a new
shortcut. I am still getting the error.

Also, when I click on the MS Access program shortcut on my desktop, a dialog
box opens and says:

Please wait while Windows configures Office 2002 XP Professional, and when
the progress bar get to the end, it opens the program as it should. It does
not do this when I open Word, Excel or PowerPoint. Just Access. I have
done a Repair of Office but it is still happening.

Thank you for your help.

Jan :)
 
Jan said:
Please wait while Windows configures Office 2002 XP Professional, and
when the progress bar get to the end, it opens the program as it
should. It does not do this when I open Word, Excel or PowerPoint.
Just Access. I have done a Repair of Office but it is still
happening.
Click to expand...

Try add the full path to msaccess.exe at the front of the target in your
shortcut. See

http://support.microsoft.com/default.aspx?scid=kb;en-us;289282

Also see
http://support.microsoft.com/default.aspx?scid=kb;en-us;815283
 
Hi Joan :-)

I have changed the path of the shortcut to the following, and it is now
opening the db without the error message.

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "C:\Documents and
Settings\jan\My Documents\Access\Jan's Checking Registry\Jan's Checking.mdb"

I have done this additional path with secured db shortcuts, but, I have not
had to use it with an unsecured shortcut before. That is why I did not even
think of it at all. I guess it has to do with the difference between WinME
and W2K, or something in W2K I'm not yet aware of. While leaning new
programs is really fun, there can be some throw rugs to trip you up here and
there for a while. ;o)

I'm still getting the "Please wait while Windows configures Office 2002 XP
Professional" message and procedure, but, at least the other error message
is gone, and the db is opening in the proper format, and not in an altered
state, so I can work in it without fear of corruption.

Thank you very much for your time and help, I truly appreciate it.

Jan :)
Smiles are meant to be shared,
that's why they're so contagious.
 
Jan said:
Hi Joan :-)

I have changed the path of the shortcut to the following, and it is
now opening the db without the error message.

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"C:\Documents and Settings\jan\My Documents\Access\Jan's Checking
Registry\Jan's Checking.mdb"

I have done this additional path with secured db shortcuts, but, I
have not had to use it with an unsecured shortcut before. That is
why I did not even think of it at all. I guess it has to do with the
difference between WinME and W2K, or something in W2K I'm not yet
aware of. While leaning new programs is really fun, there can be
some throw rugs to trip you up here and there for a while. ;o)
Click to expand...

It isn't related to W2K really. According to the KB article I referenced,
it's happening because you have two versions of Access installed, or at
least the operating system thinks you do.

http://support.microsoft.com/default.aspx?scid=kb;en-us;289282
 
Hi Joan :-)
It isn't related to W2K really. According to the KB article I
referenced, it's happening because you have two versions of Access
installed, or at least the operating system thinks you do.

http://support.microsoft.com/default.aspx?scid=kb;en-us;289282
Click to expand...

Yes...I saw that reference, however, I only have Office 2002XP installed,
and being the only Access program I have had installed and used in the past
2 years, it was the last program I opened the app in. I was installing the
2002 XP Update to the new W2K drive in the E:\CD-Rom drive, and when it
asked for the qualifying program, I put the CD for the Office 2000 in the
F:\CD-Rom drive, then after it determined it met whatever criteria, it
continued to install the Office 2002XP. Thus, there is only one Office
program installed.

Question: Could it *think* I also have the Office 2000 program installed
because I put it in the F:\ drive at the same time as I was installing from
the E:\ drive? Should I uninstall the Office 2002 XP and try reinstalling
it, taking out the 2002 install CD and putting the 2000 CD in the same
E:\drive to let it see the qualifying program, then take it out and return
the 2002 XP CD? I wondered about this at the time, but, was not sure how
W2K did things.

Thank you for your continued assistance and patience. I appreciate it very
much. :-)

Jan :)
Smiles are meant to be shared,
that's why they're so contagious.
 
Jan said:
Yes...I saw that reference, however, I only have Office 2002XP
installed, and being the only Access program I have had installed and
used in the past 2 years, it was the last program I opened the app
in. I was installing the 2002 XP Update to the new W2K drive in the
E:\CD-Rom drive, and when it asked for the qualifying program, I put
the CD for the Office 2000 in the F:\CD-Rom drive, then after it
determined it met whatever criteria, it continued to install the
Office 2002XP. Thus, there is only one Office program installed.

Question: Could it *think* I also have the Office 2000 program
installed because I put it in the F:\ drive at the same time as I was
installing from the E:\ drive? Should I uninstall the Office 2002 XP
and try reinstalling it, taking out the 2002 install CD and putting
the 2000 CD in the same E:\drive to let it see the qualifying
program, then take it out and return the 2002 XP CD? I wondered
about this at the time, but, was not sure how W2K did things.
Click to expand...

I don't really know, as I haven't any first-hand experience with this. I
think it may be due to the fact that you once had 2000 on the computer,
right? I mean why do you have the upgrade version of 2002?
Smiles are meant to be shared,
that's why they're so contagious.
Click to expand...

Thanks for that. You've managed to put a smile on mine - hasn't been there
in weeks.
 
Hey Joan!!!
I don't really know, as I haven't any first-hand experience with
this. I think it may be due to the fact that you once had 2000 on
the computer, right? I mean why do you have the upgrade version of
2002?
Click to expand...

Whoohoo!!!! 'k....I figured it out! Here's what I did...

I uninstalled the Office 2002XP and then rebooted to make sure all was
clear. Then I reinstalled it by doing the following:

Placed the 2002 XP install CD in the E:\ CD-Rom drive and started the
install process.
When it asked for the qualifying program, I removed the 2002 XP CD and put
in the 2000 CD and set the drive source to the E:\ drive. Once it went to
the 'Accept' window, I took the 2000 CD out and put the 2002 XP CD back in
the E:\ drive and then had it finish the install process. Then I rebooted to
make sure all the ingredients were well blended.

Well....guess what?!?!? Yeppers! The main MS Access program desktop
shortcut opens with no dialog box about installing and configuring the 2002
XP.....AND.....I tried creating new shortcuts by just right clicking the
file and then selecting Create shortcut, and putting them on the desktop,
and....they now open the respective db's without the error message, and I
don't need the "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"!

Heh! Whadda ya know.... it worked!! ;o)
Thanks for that. You've managed to put a smile on mine - hasn't been
there in weeks.
Click to expand...

Ohh...you're very welcome! You've put one on mine many times here. <s>

Thank you so much for all your time and help, and patience, I really do
appreciate it.

Jan :)
Smiles are meant to be shared,
that's why they're so contagious.
 
Hey Jan! Glad you got it working! Ah, persistance pays off... What's that
song about the rubber tree plant?? ;)

Fred
 
Fred said:
Hey Jan! Glad you got it working! Ah, persistance pays off... What's
that song about the rubber tree plant?? ;)
Click to expand...

Oh....I thought it was the 'lil ant.... ;-))

Thanks Fred. But...you know me...my curious just won't allow me to let go
'til I find an answer. It's hard learning a new program, and not knowing
all the persnickerties of them up front makes it a bit harder sometimes too.
I don't understand the difference in the way the install was done, between
using one drive and the other, but, hey....I don't write these programs, I
just have to figure out how to use 'em. :o)

Thankfully, there's this wonderful group of people who are kind and generous
enough to come here and try to help all us do just that. :)

Jan :)
Smiles are meant to be shared,
that's why they're so contagious.
 
Back
Top