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
5  4064 
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.goo gle.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.
Chris
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! cf******@yahoo. com (Chris Dugan) wrote in message news:<82******* *************** ****@posting.go ogle.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 br***@aristotle .net (Bruce) wrote in message news:<d3******* *************** ****@posting.go ogle.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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 'X', a 'space' and the '=', if I wait a second, I get
just 'X=' in red (like when you've got a syntax error)
when I quickly type in 'X', '=' and '"', after a second I get 'X = ""'
(making it hard to enter a string)
|
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, city, state, etc.
When the user wants to search for a particular record, he does two
things:
1. On the form is a text box on which he enters the text he is searching
for.
|
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 Number: PK), ParentID(FK to
ID in parent Table) and Name(Childs Name)
The tables are related by the ID and ParentID
|
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 front end) add a
record to an existing table. Here is the code:
If arg = cintBatchReg Then
Set newrec = db.OpenRecordset("SELECT * FROM ", _
dbOpenDynaset, dbSeeChanges)
Set newrec = db.OpenRecordset("SELECT * FROM _
", dbOpenDynaset,...
|
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 ?
| | |
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 and run several
queries in it then close that another db.
ex:
button1 - open db -> Cash, run 3 queries in it, then close it.
button2 - open db -> Credits, run four queries in it, close it.
etc.....
|
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 laptop and
connects to our LAN.
The code works fine if there are no other users accessing the server's
BE at the time. If the file-server's BE is open at the time, however,
then the relinking process does not finish -- it just pauses. When...
|
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 form, the code
errors out at the 2nd line. The error number is 13 and the description
is "Type mismatch". Both controls are memo fields. I suspect that
"Screen.ActiveControl.Parent" is not referencing the form as intended.
Thanks for any help,...
|
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 Access2003 respectively. The table in Access97 returns 874 rowcount, table in Access 2003 returns 1050 rowcount. In both the case the querydef is retrieving from the same database which resides in SQL Server 2003.
I executed the application Access97 and...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
