Access97 under XP job

D

david beattie

I'm not used to newsgroups; apologies for any unintentional discourtesies.
Any reply to (e-mail address removed) , please.

Summary: I'm pretty ignorant about computing. Before buying a new computer
with XP Home Edition, I'd like to pay an expert to convert my Access97
database.

In Detail: My Access 97 is part of Office 97 Professional. It runs under
Windows 98 SE, on a 1024 x 768 display. The database is a single 360meg
..mbd file (ie, not split, I assume), with another 200meg of photos etc that
it uses. It has around 40 fields and 5000 records. When complete, it will
have around 10,000 records. A couple of years ago, at my request, a
professional made some changes to the way things work; unfortunately, he got
carried away, and I had to crudely amputate some of his clever, but
counter-effective, creations. So the database works fine, but there is
plenty of room for improvement, and "behind the scenes" things may be messy
in places.
The new computer I'm considering, a Sony PCV W2 or its successor, uses
XP Home Edition and a 1280 x 768 display. Attempts to install or run the
database on friends' computers under XP result in a series of increasingly
incomprehensible message boxes.
The database is about Dartmoor. I lend copies, on CD, to other
Dartmoor enthusiasts, many of whom may never abandon Windows 98. So
although my first priority it to get it running at least as well under XP as
it runs under 98, so that I can continue building and editing it, I must try
to make sure that "reference" copies can still be provided to users of other
versions of Windows.
This newsgroup regularly offers advice relating to the job I've
described. I can see that the job, for a skilled person, could be easy, or
difficult.

Any reply to (e-mail address removed) , please, because wierd Eurobell sends my
emails under one username, but refuses to accept anything addressed to that
name.

With thanks to whoever made this newsgroup available.

David
 
D

Douglas J. Steele

Just because you switch from Windows 98 to Windows XP doesn't necessarily
affect your version of Access. If you install Office 97 on your new machine,
you won't need to do any conversion. If you decide to get a newer version of
Office, in general the newer version of Access will offer to convert your
older application for you automatically the first time you open the old
application.
 
D

david epsom dot com dot au

because wierd Eurobell sends my emails under one username,
but refuses to accept anything addressed to that

A very sensible approach, designed to limit spam and viruses.
You should NEVER post your true email address in plain text
here, because spammers use automatic programs to scan these
news groups for email addresses.

(david)
 
P

Peter Gillett

Just because you switch from Windows 98 to Windows XP doesn't necessarily
affect your version of Access. If you install Office 97 on your new machine,
you won't need to do any conversion. If you decide to get a newer version of
Office, in general the newer version of Access will offer to convert your
older application for you automatically the first time you open the old
application.

I am sure that I have read somewhere (I thought in this group) that
Access97 did not run well under WinXP.
It is one of the reasons that I have not yet upgraded from Win98.

peter
 
D

david beattie

Thank you Doug, Peter and David, and anyone else who has very recently
replied to my query.

It certainly seems logical that the existing, unchanged database should run
perfectly after installing Office97 on the new computer running under XP.
But previous attempts have failed. If I remember rightly, the first msgbox
refers to compiling, and when that's done, further msgboxes complain about
code. Where do I go to get this job done skilfully?

David
 
D

Douglas J. Steele

Peter Gillett said:
I am sure that I have read somewhere (I thought in this group) that
Access97 did not run well under WinXP.
It is one of the reasons that I have not yet upgraded from Win98.


I'm not having any problems running 97 under XP, nor have I heard of any
reports of problems from others.
 
A

Albert D. Kallal

david beattie said:
Thank you Doug, Peter and David, and anyone else who has very recently
replied to my query.

It certainly seems logical that the existing, unchanged database should
run
perfectly after installing Office97 on the new computer running under XP.
But previous attempts have failed. If I remember rightly, the first
msgbox
refers to compiling, and when that's done, further msgboxes complain about
code.

As mentioned, you should not be having problems running access97 on windows
xp. I have LOTS of clients running access97 software. When they went to
windows xp, they installed access97, and my stuff works just fine. So, as a
general rule, you should not have to change, or do anything.
Where do I go to get this job done skilfully?

I am sure any competent access developer could take a look at your setup,
and get it working for you. You might check out the local colleges, or
university's and find out if there are any local computer or users groups.
These users groups can be a great starting point for local help. If you want
to start spending some real money...then I suppose you could always open the
yellow pages. Only you can balance the needs between going the "self help"
way, or to spend your way out of this problem.

And, the help here is certainly free!

You could start trouble shooting a bit here also. For example, can you
create, and run other access programs? Do all not work, or just the one
application you are talking about?

Also, those photos should not be stored in your database. I have database
with 100,000 records, and they are less then 10 megs in size. So, you 360
meg file sound rather large.
 
H

hile trotman

David, doug:

I myself am having problems with 97 versions of excel and access on winxp.
Doug you are half right. My tech group told me that once we removed a 512
chip from the desktops the install worked fine. However, it does not work if
you have 1gig memory. David perhaps your friend's PC has 1gig of memory. When
office 97 was developed there was no 1gig, it's a 16bit app so it will not
work.

The reason why I'm posting however, and perhaps Doug can help me: is there
any patch that can solve this issue so that I can load excel and access 97 on
XP with 1gig machines? I have not been able to do this and we need the extra
memory to run some big reports.

To you David, if you have or reduce your pc to 512 the access 97 install
should go w/o a problem.

Thanks
HT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top