473,326 Members | 2,147 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access 97 and Windows XP SP2

I have Access 97 on a computer with Windows XP at SP1 level

The policy where I work is to have Windows AutoUpdate ON, but
I have mine set to OFF until I find out if there are problems
with Access 97 after installing XP Service Pack 2

Anyone have any experience with this?

John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith
Nov 13 '05 #1
7 2623
The only problem I'm having is the problem I had with SP1 as well. I try to
run a pivot table with the form wizard and when I update it, throught Excel,
it kicks me out of Excel. Other then that Access 97 has worked fine with
SP2
"John Thomas Smith" <jt*****@pacifier.com> wrote in message
news:7m********************************@4ax.com...
I have Access 97 on a computer with Windows XP at SP1 level

The policy where I work is to have Windows AutoUpdate ON, but
I have mine set to OFF until I find out if there are problems
with Access 97 after installing XP Service Pack 2

Anyone have any experience with this?

John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith

Nov 13 '05 #2
T Martin wrote:
The only problem I'm having is the problem I had with SP1 as well. I try to
run a pivot table with the form wizard and when I update it, throught Excel,
it kicks me out of Excel. Other then that Access 97 has worked fine with
SP2


I don't mean to hijack the thread, but did either of you folks have
trouble with installing A97 and writing the system.mdw to the system32
directory in your windows directory?

I was unable to do so and had to create one elsewhere. The PITA is that
I have to open all A97 apps from A97 itself or create a shortcut
specifying the location of the ork group.

I've heqard second hand some not nice things about win XP SP 2, though
just general stuff, nothing wrt Access 97.

Thanks.
--
Tim - http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #3
>I don't mean to hijack the thread, but did either of you folks have
trouble with installing A97 and writing the system.mdw to the system32
directory in your windows directory?


I installed ONLY Access97 from the full OfficePro97 CD and did
not have any problems at all
John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith
Nov 13 '05 #4
My database is very plain, so should work OK (I hope!) The only thing
that I think "could" be the least bit worrisome is I have a macro to
read an external text file (created by a barcode scanner and uplinked
to my computer via a file transfer program which came w/the scanner)

Once the text file is imported into the database (the import process
should be OK, but I keep reading stories about Sp2's new security
settings causing various problems, so have wondered...) it is all a
very simple set of menu buttons to read the file and print lots of
daily or by request reports

Unless someone posts here about some major problem, I guess I'll do
the Sp2 upgrade in a day or two
The only problem I'm having is the problem I had with SP1 as well. I try to
run a pivot table with the form wizard and when I update it, throught Excel,
it kicks me out of Excel. Other then that Access 97 has worked fine with
SP2
I have Access 97 on a computer with Windows XP at SP1 level

The policy where I work is to have Windows AutoUpdate ON, but
I have mine set to OFF until I find out if there are problems
with Access 97 after installing XP Service Pack 2

John Thomas Smith
http://www.direct2usales.com
http://www.pacifier.com/~jtsmith
Nov 13 '05 #5
Tim Marshall <TI****@antarctic.flowerpots> wrote:
The only problem I'm having is the problem I had with SP1 as well. I try to
run a pivot table with the form wizard and when I update it, throught Excel,
it kicks me out of Excel. Other then that Access 97 has worked fine with
SP2
I don't mean to hijack the thread, but did either of you folks have
trouble with installing A97 and writing the system.mdw to the system32
directory in your windows directory?

I was unable to do so and had to create one elsewhere. The PITA is that
I have to open all A97 apps from A97 itself or create a shortcut
specifying the location of the ork group.


This is likely due to you running your system as a regular user. Which is a good
thing. Trouble is many apps want you to run as an administrator. Which leaves
your system more open to hijacking and malware and such.
I've heqard second hand some not nice things about win XP SP 2, though
just general stuff, nothing wrt Access 97.


I've seen a few similar comments but much of that seems to be due to spywere and such
installed on the system. Or software which isn't compatible with XP2.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #6
John Thomas Smith <jt*****@pacifier.com> wrote:
I have Access 97 on a computer with Windows XP at SP1 level

The policy where I work is to have Windows AutoUpdate ON, but
I have mine set to OFF until I find out if there are problems
with Access 97 after installing XP Service Pack 2


No problems here but I'm running as administrator. One of these days, when I have
the time Real Soon Now, I'm going to run as user and document the problems I will
encounter.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #7
Tony Toews <tt****@telusplanet.net> wrote in
news:6p********************************@4ax.com:
Tim Marshall <TI****@antarctic.flowerpots> wrote:
The only problem I'm having is the problem I had with SP1 as
well. I try to run a pivot table with the form wizard and when
I update it, throught Excel, it kicks me out of Excel. Other
then that Access 97 has worked fine with SP2


I don't mean to hijack the thread, but did either of you folks
have trouble with installing A97 and writing the system.mdw to the
system32 directory in your windows directory?

I was unable to do so and had to create one elsewhere. The PITA
is that I have to open all A97 apps from A97 itself or create a
shortcut specifying the location of the ork group.


This is likely due to you running your system as a regular user.
Which is a good thing. Trouble is many apps want you to run as
an administrator. Which leaves your system more open to
hijacking and malware and such.


And the original design of Access putting user components in
System32 was a bad architecture in the first place. User files (like
a local workgroup file) belong anywhere but in the OS's system
folders, which should be off limits in terms of writability to plain
old users.

And this change in design (locking down the OS directory) was made
in Windows 2000, not in Win2K. NT 4 was less stable than Win2K
precisely because it still allowed user-level write access to the
WINNT folder.
I've heqard second hand some not nice things about win XP SP 2,
though just general stuff, nothing wrt Access 97.


I've seen a few similar comments but much of that seems to be due
to spywere and such installed on the system. Or software which
isn't compatible with XP2.


A number of programs of all different kinds have problems with SP2.
For instance, just today, a user brought her laptop to me to show me
that the Outlook Web Access web page doesn't work for her -- she
can't reply or forward messages. We opened IE on my PC (Win2K) and
logged her on and she had no problems with functionality. Her PC was
Win2K SP2. I suspected popup blocking, but turning that off or
turning it on and allowing their mail server to open popups didn't
fix it.

I'm telling my WinXP clients (just a handful, since I kept most of
them away from it) to hold of on SP2. They are at no security risk
because of this since they are already appropriately firewalled and
secure via non-OS means.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
13
by: BigDaDDY | last post by:
Um yeah....In case you haven't figured it out, Microsoft sucks. I'm going to be kicked back in my chair eating popcorn and watching football 10 years from now, while all you clowns are scrambling...
33
by: Uwe Range | last post by:
Hi to all! A customer of mine told me some days ago that her IT-people told her ACCESS would not be such a good idea for continuing with our project, because Access will not be continued in the...
16
by: Brad | last post by:
After compiling my asp.net project I'm receiving a "BC31011 - Access is denied" error when attempting to run or debug. The only thing that seems to resolve problem is IISReset. After a reset my...
4
by: James | last post by:
I have a VB windows forms application that accesses a Microsoft Access database that has been secured using user-level security. The application is being deployed using No-Touch deployment. The...
6
by: dbuchanan | last post by:
I have a Windows Forms application that accesses SQL Server 2k from a small local network. The application has been used for weeks on other systmes but a new install on a new machine retruns...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
22
by: Jordan S. | last post by:
SQL Server will be used as the back-end database to a non trivial client application. In question is the choice of client application: I need to be able to speak intelligently about when one...
21
by: nihad.nasim | last post by:
Hi there, I have a database in Access that I need on the web. The web page should connect to the database and write records for certain tables and view records for others. I want to know a...
6
by: Wesley Peace | last post by:
I hate to cross post, but I've gotten no answer yet on a problem I'm having with visual studio 2008. I've created a series of forms with controls to access a Access database tables. The...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.