G
GLK_Jeff
Ever since I installed Microsoft Windows XP Service Pack 2 a few weeks ago,
we have been having problems with a simple Microsoft Access database I
developed 7 years ago in Access 97, and eventually was converted to Access
2002 3 years ago. The database was working fine without any problems until I
installed Service Pack 2.
Background:
The database is located on one computer's harddrive, and 5 other computers
are using the database via a basic peer-to-peer network using a fast Ethernet
switch. We are all using Microsoft Windows XP Professional and Microsoft
Office XP. I have installed Windows XP Service Pack 2 on 3 of the 5
computers using the database, but the problem is occurring on all 5 of the
computers that use the database (it doesn't happen on the computer that has
the database on its harddrive). The machines were purchased brand new from
Dell 2.5 years ago, and are the Dimension 4400 series.
Problem:
For no apparent reason, a computer can get arbitrarily kicked out of the
database, with the error message "Disk or network error", and the person on
that computer must click on that error message many times and then exit out
of Access and get back into the database. It happens every day on some
machines, only every several days on others. The only pattern I can see is
that it happens within the first 10 to 15 minutes of booting up, then once
you click off all the error messages and exit out and get back into the
database, for the rest of the day, it is fine. It has never happened on the
computer that has the database on its harddrive.
Please help - this is frustrating and affecting our productivity. I love
Microsoft products, and I actually have my own computer consulting business
that uses strictly Access (and sometimes SQL Server as a back end), however,
I need to get this conflict with SP2 resolved. On my home machine, I
installed SP2, and now one of my USB devices won't work, and apparently
Microsoft has acknowledged that to be a problem. The device doesn’t have an
external power supply, so I am pretty much stuck with the option of
uninstalling SP2 in order to use the device, but I doubt Microsoft would
recommend that. I am only bringing this up to give you an example of another
problem I had with SP2, and from what I have read, others are having some
problems also.
Thanks for your help on the database issue outlined above.
we have been having problems with a simple Microsoft Access database I
developed 7 years ago in Access 97, and eventually was converted to Access
2002 3 years ago. The database was working fine without any problems until I
installed Service Pack 2.
Background:
The database is located on one computer's harddrive, and 5 other computers
are using the database via a basic peer-to-peer network using a fast Ethernet
switch. We are all using Microsoft Windows XP Professional and Microsoft
Office XP. I have installed Windows XP Service Pack 2 on 3 of the 5
computers using the database, but the problem is occurring on all 5 of the
computers that use the database (it doesn't happen on the computer that has
the database on its harddrive). The machines were purchased brand new from
Dell 2.5 years ago, and are the Dimension 4400 series.
Problem:
For no apparent reason, a computer can get arbitrarily kicked out of the
database, with the error message "Disk or network error", and the person on
that computer must click on that error message many times and then exit out
of Access and get back into the database. It happens every day on some
machines, only every several days on others. The only pattern I can see is
that it happens within the first 10 to 15 minutes of booting up, then once
you click off all the error messages and exit out and get back into the
database, for the rest of the day, it is fine. It has never happened on the
computer that has the database on its harddrive.
Please help - this is frustrating and affecting our productivity. I love
Microsoft products, and I actually have my own computer consulting business
that uses strictly Access (and sometimes SQL Server as a back end), however,
I need to get this conflict with SP2 resolved. On my home machine, I
installed SP2, and now one of my USB devices won't work, and apparently
Microsoft has acknowledged that to be a problem. The device doesn’t have an
external power supply, so I am pretty much stuck with the option of
uninstalling SP2 in order to use the device, but I doubt Microsoft would
recommend that. I am only bringing this up to give you an example of another
problem I had with SP2, and from what I have read, others are having some
problems also.
Thanks for your help on the database issue outlined above.