cf******@yahoo.com (Chris Dugan) wrote in message news:<82**************************@posting.google. com>...
Hi,
has anybody come across a solution to running an Access97 database on
Windows XP. The situation I have is an Access 97 database that runs
perfectly from Win95/98 clients running Access97, the database sits on
a Windows2000 server to which everyone has full NTFS access rights.
The problem is the WinXP and Win2k clients which appear to run fine
(also running Access97) in reading any existing data but as soon as
you attempt to edit a field the cursor sits in the field and a message
appears at the bottom LH corner of the program saying 'This Recordset
is not updateable'. I have checked the NTFS security settings on
everything that I can to give everybody full rights(both server and
client) and have given users local admin rights on their pc's but
still to luck.
I know somebody will say it's not a supported solution (XP and 2k
running Office97) but the Access database is bespoke and can't be
easily migrated to office 2k (the company that did it have gone to the
wall and left no development info behind). Thanks to anybody who has
any pointers to help solve this tricky situation.
We run multiple Access 97 applications on Windows XP clients connected
to a Windows 2000 server with no problems at all. Some of these are
split applications, i.e., front end resides on XP desktop and back end
resides on server, and a couple of them are all-in-one databases that
reside strictly on the server (not my preference but these were
supplied by outside sources and we have no control over whether or not
they're split). Regardless, all of them run fine without the problems
you describe. I'm not aware of any statement by Microsoft or anyone
else stating that this is 'not a supported solution'. I think there's
something going on with your Access installation or your specific
application that's the problem. Try putting the northwind database
supplied with Access 97 on your server and see if you can update it
from the XP clients. If not, I suspect there's an issue with your
Access installation. Have you installed all of the latest Office 97,
Windows XP, and 2000 Server service packs? I would definitely do all
of these if you haven't yet done so. In fact, I seem to recall some
kind of file locking problem addressed by a service pack for Windows
2000 server, but my memory is hazy...
HTH,
Bruce