473,322 Members | 1,526 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,322 software developers and data experts.

Problem running Access97 on XP

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.

Chris
Nov 12 '05 #1
5 4041
Did you copy it via CD and not change the file proprerties to read only
false

Phil

"Chris Dugan" <cf******@yahoo.com> wrote in message
news:82**************************@posting.google.c om...
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.

Chris

Nov 12 '05 #2
Hi Phil,

No the database sits on a server, it is the same one that is reached
from the win 95 and 98 clients with no problems, that (read only
attribute) and the NTFS file permissions are what i have checked so far
and as I don't really understand the internals of Access i'm a bit stuck
on where to proceed.

Chris

Remove obvious to reply

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3
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
Nov 12 '05 #4
br***@aristotle.net (Bruce) wrote in message news:<d3**************************@posting.google. com>...
<snip>
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


Thanks Bruce, that might be it (the file locking issue). I also found
out about a registry fix for 2k/xp that allows for a plain text
password for the lanman wkstn service which might also be something to
look at.

The file locking was a reg hack that can be done on any version of
Win2k but now you mention it I also have a similar recollection of
either sp3 or 4 having further fixes for that problem.

The app runs as a split db not all residing on the server but that's
about all the info I can give you on it. What I meant by 'not a
supported solution' was that MS have not ested the combination and so
won't provide any support, so usually neither will any of their
partners.

Thanks again,

Chris
Nov 12 '05 #5
On 5 Nov 2003 03:02:17 -0800, cf******@yahoo.com (Chris Dugan) wrote:

Hi Chris,

We rum both Access97 and Access2002 at the same time on our XP
systems. The solution to this installation is in the Microsoft
Knowledge base article 241141

Regards,

Phil

Nov 12 '05 #6

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

Similar topics

1
by: Roger | last post by:
running on XP pro adding vba code, I want to type in 'X = "good"' when I type the 'X', and a 'space', if I wait a second, the cursor automatically moves back over the 'space' when I type the...
10
by: DataBard007 | last post by:
Hello Access Gurus: I use Win98SE and Access97. I just built a simple Access97 application which holds all contact information for my personal contacts, such as first name, last name, address,...
2
by: Ray Bell | last post by:
There are 2 tables, a table called parent and a table called child. The parent table has 2 fields, an ID (AUTO Number: PK) and Name (Parent Name) The Child Table has 3 fields, an ID (AUTO...
8
by: Rebecca | last post by:
We are converting my Access97 back end to SQL Server and almost have it all working. The current problem has to do with one situation in which I have to programmatically (still in the Access97...
4
by: Paul | last post by:
Is it possible to run an Access 2000 database on a PC with only Access97 installed? I.e. Could you use a Access 2000 runtime ?
0
by: vulcaned | last post by:
Hi All, In Access97 I have a database(MasterControl), it has a form(MainMenu) with four buttons on it. On the click event of each button on the MainMenu form I want it to open another Access97 db...
23
by: cmd | last post by:
I use the following code (behind a command button on the FE) to relink from a user's local copy of the BE to the file-server's BE on our LAN. I use this, for example, when a person brings in their...
21
by: cmd | last post by:
I have code in the OnExit event of a control on a subform. The code works properly in this instance. If, however, I put the same code in the OnExit event of a control on a Tab Control of a main...
3
by: Ramchandar | last post by:
Hi, I am creating reports using VBA code. I have the same query in a querydef residing both in Access97 and Access2003. The result of this querydef is then moved to a table in Access97 and...
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...
0
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: 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: 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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.