Microsoft office 97 access

[r.broman]

I have a notebook computer with windows xp. I have windows 97 installed on
the computer. All programs work except Access. This gives an immediate
error message "Can't find the database you specified, or you didn't specify
a database at all. Specify a valid database name in the command line, and
include a path if necessary"
Any ideas as to what steps are needed to correct this problem.?
thanks for any help

 

['69 Camaro]

Hi.

Assuming the problem is with Access 97, not Windows 97 (which doesn't
exist), perhaps some of the following MS Knowledge Base articles will help:

http://support.microsoft.com/kb/235280

http://support.microsoft.com/default.aspx?id=235279

http://support.microsoft.com/default.aspx?id=241738

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[r.broman]

I have a notebook computer with windows xp. I have windows 97 installed on
the computer. All programs work except Access. This gives an immediate
error message "Can't find the database you specified, or you didn't specify
a database at all. Specify a valid database name in the command line, and
include a path if necessary"
Any ideas as to what steps are needed to correct this problem.?
thanks for any help

thanks for the help to camaro 69 I can't find your direct email return.
When I click the reply button, this is the only response available.

You were right about windeows 97---I meant OFFICE 97 pro. I am not sure how
the problem corrected as I had to follow the remove and reinstall process
three times. Third time lucky. Access now opens. However, as a rank
amateur I now have to figure out how to convert NEWER Access databases on my
desktop running Windows XP with Office 2002 Professional so that I can use
them on
the older OFFICE 97 program. I know that there is a way to convert
backwards but I can't quite figure this out. Any further suggestions greatly
appreciated.
I read all articles suggested. I think the first one was most effective.
However, for a newbie the instructions regarding reinstall were a little
unclear as they suggest that only access would be re-installed after removing
Office 97 as outlined. This caused some of the difficulty in getting the
thing to work.
Thanks again to Camaro 69. I hope your collector car is as hot and good as
your assistance has been.
Roy Broman

 

['69 Camaro]

Hi.

thanks for the help to camaro 69 I can't find your direct email return.
When I click the reply button, this is the only response available.

You're welcome. Your responses aren't really E-mail messages that go to a
single person's E-mail client. Your responses will be posted to UseNet
where I (and the rest of the world) can read and respond to them.

I now have to figure out how to convert NEWER Access
databases on my desktop running Windows XP with Office 2002
Professional so that I can use them on
the older OFFICE 97 program.

Open the database in Access 2002 and select the Tools menu -> Database
Utilities -> Convert Database -> To Access 97 Format... and then follow the
prompts to convert it to an Access 97 version. As long as you haven't added
any features that weren't available in Access 97, then the conversion should
go pretty smoothly, but there's no guarantee that it will be perfect. You
may need to do some tweaking. Specifically, you'll need to look at the
References in the newly converted database to ensure that the Microsoft DAO
Object Library is listed as DAO 3.51 (for Access 97 and Jet 3.5), not DAO
3.6 (for Access 2000 and later and Jet 4.0).

However, for a newbie the instructions regarding reinstall were a little
unclear as they suggest that only access would be re-installed after removing
Office 97 as outlined.

Yes. That GUI is very confusing for experienced software installers as
well, so don't feel bad.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[r.broman]

Thanks for the great assistance. I did find the conversion process easily in
Access 2000/2002 and was able to make the conversion easily. As the
database is very simple, it appears to have converted completely without any
glitches. Therefore, the more technical aspects were not necessary.
I hope that someone gives you credit from time to time for your willingness
to help others who are struggling
Thanks again.
Roy Broman
PS All problems solved until the next one arises.

 

['69 Camaro]

Hi, Roy.

You're welcome. Glad to help.

I hope that someone gives you credit from time to time for your willingness
to help others who are struggling

There are many ways to access the newsgroups, but Microsoft created an
online community Web site that allows the users to give feedback and mark
responses to their posts as the correct "Answer" and "Helpful" or
"Unhelpful." This way, future searchers can find the correct answers to
their similar questions more quickly. I see that you've marked both of my
responses as helpful, and the first one as the correct answer, so thank you
very much! About three percent of the people who ask questions in the
newsgroups go to Microsoft's online community Web site to provide feedback,
so your efforts are very much appreciated.

Your two "Helpful" marks make up for another person I was helping elsewhere
for three days with five separate issues with her network and Access
installations and configurations that lock her out of some of her databases.
I've spent probably ten times as much time helping her as I have helping
you, and she finally marked my latest response as the correct "Answer," but
"Unhelpful." I think I'll quit helping her resolve her last issue while I'm
only behind by one!

PS All problems solved until the next one arises.

We'll be waiting! Have a great day.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Fred Boer]

Dear Gunny:

I use Outlook Express to access the newsgroups, so I didn't know about the
possibility of "evaluation" of answers in the Microsoft Web Newsgroup
reader. It rather takes me aback to imagine that I might be "rated" on my
answers! I suppose it would be possible for Microsoft to keep statistical
records of this data as well. Of course, it's Microsoft's system, so they
can do what they want, but still, I do find it a bit unsettling! Of course,
I am kind of used to this... I mean, sites such as Ratemyteacher.com, have
given students a lovely opportunity to take potshots at us teachers for some
time!

Fred Boer

P.S. I think I'll go and rate this message as very helpful!!

 

['69 Camaro]

Hi, Fred.

Congratulations! You now have another post rated "1 out of 1 people found
this post helpful." Only two more people need to log in and rate your post
as helpful before it will be marked in the Microsoft online community as a
"Helpful" post in green text. (Unless, of course, someone marks it as
"Unhelpful." Then you'll need soneone else to mark it as a helpful post to
counterbalance the unhelpful ones.) Each post just needs a 2/3 majority and
a minimum of three ratings to get the official "Helpful" marking in green
text, so that future searchers can filter for the "Helpful" posts in
Microsoft's database of UseNet answers.

I suppose it would be possible for Microsoft to keep statistical
records of this data as well.

They do. The plan is to help future searchers find the best answers
quickly, because each post can be rated with the online community's
feedback. Each poster who answers 50 questions or more will get a bronze
medal icon next to his name to indicate to others how many correct answers
he's given. Each poster with 100 correct answers or more will get a silver
medal icon next to his name, and each poster with 500 correct answers or
more will get a gold medal icon next to his name, and the MVP's will get a
blue MVP medal icon next to his name to give searchers an idea of the
quality of answers that the individual gives.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Jeff Conrad]

They do. The plan is to help future searchers find the best answers
quickly, because each post can be rated with the online community's
feedback. Each poster who answers 50 questions or more will get a bronze
medal icon next to his name to indicate to others how many correct answers
he's given. Each poster with 100 correct answers or more will get a silver
medal icon next to his name, and each poster with 500 correct answers or
more will get a gold medal icon next to his name, and the MVP's will get a
blue MVP medal icon next to his name to give searchers an idea of the
quality of answers that the individual gives.

I'm making room on my desk for my Cubic Zirconium medal as we speak.....

<vbg>
--
Jeff Conrad
Access Junkie
Bend, Oregon

in message news:[email protected]...

 

['69 Camaro]

Hi, Jeff.

I'm making room on my desk for my Cubic Zirconium medal as we speak.....

You'd better be a mighty fast runner! There's only going to be one of those
medals and Doug Steele's got dibs on it. You'll have to grab it from his
desk and run for the border! ;-)

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Fred Boer]

Dear Gunny and Jeff:

I was going to offer to mark all of both of your posts as "Helpful" from now
on, but just marking my own was such a hideous experience I'm afraid you are
both on your own. That web interface is so awful and slow that I'm never
going back! How *do* people put up with it! Never again....

Fred

 

['69 Camaro]

Thanks, Fred!

I was going to offer to mark all of both of your posts as "Helpful" from now
on, but just marking my own was such a hideous experience I'm afraid you are
both on your own. That web interface is so awful and slow

Thanks for considering volunteering to be a sponsor! (It's the thought that
counts!) My description for Microsoft's Web interface isn't nearly as kind
as yours. ;-)

The Web interface is so cumbersome that only 8.5% of threads that show up in
the Access Online Community are marked as having "Answers." That may seem
like a small percentage, but when compared to how many threads are marked
with an answer when no MVP is involved in the thread (3.2%), it shows that
the MVP's efforts are having a significant impact in bringing this average
up. (Only the original poster or an MVP can mark a message as an "Answer.")

It also means that if one didn't have help from an MVP "sponsor" and had to
rely solely on people who post questions to return to the Microsoft Online
Community to mark a post as the "Answer," then on average, non-MVP's would
have to post at least one correct answer to each of about 1,600 threads in
order to earn the 50 "Answers" required for the bronze metal icon next to
their names. Without sponsorship, very few non-MVP's would ever acquire the
bronze, let alone the silver or gold icons.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)