473,714 Members | 2,623 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem installing Access 97 with Windows XP - "error occurred changing the workgroup database"


I have a licensed MS Office 97 package which I have moved from PC to PC
over the years and I have just bought a new machine with XP Pro on it,
the latest release. When I install Office, I get the error "an error
occurred at changing the workgroup database" and "setup couldn't create a
system.mdw file....run the workgroup administrator before you run this
appliaction (-1011). When I run the workgroup administrator (something I
have never had to do before) it simply tries to remake this file and the
first error appears again.

The rest of Office installs fine. When I try to launch Access, I get the
message "microsoft access couldn't find the file .../system.mdw. This
file is required for startup" (path removed for brevity).

It worked fine on my last machine, which ran XP Pro Service Pack 2
(2002). And when I look for a file system.mdw on that machine, there is
none there.

Can anyone help me with this?

TIA.

Nov 13 '05 #1
5 16439
richard wrote:
It worked fine on my last machine, which ran XP Pro Service Pack 2
(2002). And when I look for a file system.mdw on that machine, there is
none there.


I had this vexing problem last Fall. From what I can gather on posts
vaguely related to this issue since my porblem, is there is a problem
when you've got more than 512 megs of RAM on the machine that causes this.

Quite simply, if you're getting this error, XP is not allowing Access to
create a system.mdw in the windows/system32. What I did was turn off
the read only property for this directory and then select everything
inside the directory and do the same. I believe I was then able to
create a system.mdw file in there using the workgroup administrator.

If that doesn't work, you can do what I did for a while, which was to
use the workgroup administrator to create a system.mdw somewhere lee
besides windows/system32. I plopped it right into my main directory
where I kept my A97 apps.

BTW, I did not have this problem on my XP machine until after I
installed Access 2003.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #2
In article <d3**********@c oranto.ucs.mun. ca>,
TI****@PurplePa ndaChasers.Moer therium opined thusly:


richard wrote:
It worked fine on my last machine, which ran XP Pro Service Pack 2
(2002). And when I look for a file system.mdw on that machine, there is
none there.


I had this vexing problem last Fall. From what I can gather on posts
vaguely related to this issue since my porblem, is there is a problem
when you've got more than 512 megs of RAM on the machine that causes this.

Quite simply, if you're getting this error, XP is not allowing Access to
create a system.mdw in the windows/system32. What I did was turn off
the read only property for this directory and then select everything
inside the directory and do the same.

Thanks for this tip - but I find that XP automaticallt sets all folders back
to read-only. However I can make folders and files OK so I made a dummy
system.mdw file in a directory c:\temp and attempted to have the workgroup
manager overwrite it with the correct file, but the same error message just
keeps showing up. Any more help would be greatly appreciated.

Nov 13 '05 #3
richard wrote:
Thanks for this tip - but I find that XP automaticallt sets all folders back
to read-only. However I can make folders and files OK so I made a dummy
system.mdw file in a directory c:\temp and attempted to have the workgroup
manager overwrite it with the correct file, but the same error message just
keeps showing up. Any more help would be greatly appreciated.


What I did was similar, except after turing read only off of everything
INSIDE system32 I just dragged the system.mdw to system32.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto
Nov 13 '05 #4
In article <d3**********@c oranto.ucs.mun. ca>,
TI****@PurplePa ndaChasers.Moer therium says...


richard wrote:
Thanks for this tip - but I find that XP automaticallt sets all folders back
to read-only. However I can make folders and files OK so I made a dummy
system.mdw file in a directory c:\temp and attempted to have the workgroup
manager overwrite it with the correct file, but the same error message just
keeps showing up. Any more help would be greatly appreciated.


What I did was similar, except after turing read only off of everything
INSIDE system32 I just dragged the system.mdw to system32.


OK thanks, I copied my system.mdw from another machine, and now I'm free of
this error, but I'm getting an "out of memory" error when I launch Access. I
have 2GB and nothing running! Aby ideas on that?

thanks.

Nov 13 '05 #5
richard wrote:
OK thanks, I copied my system.mdw from another machine, and now I'm free of
this error, but I'm getting an "out of memory" error when I launch Access. I
have 2GB and nothing running! Aby ideas on that?


Unfortunately not, I haven't come across this error myself. However, it
does sound familiar - I'd google this group and/or look through the
knowledgebase articles at MS.

Cop out answer, sorry. 8(

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #6

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

Similar topics

9
1966
by: Wally | last post by:
I am trying to display images from an Access 2000 database and I get an error "Invalid Parameter Used" when I execute the code line "picBLOB.Image = Image.FromStream(stmBLOBData)" in my Visual Basic .Net application. I have researched MSDN for help and found the example article 321900 (see below) and set up a test and everything works fine when I use SQL Server 2000 but when I modify the code and use data from Access 2000 using an...
3
8831
by: Brian Foree | last post by:
I am developing an ASP.NET application that uses Access 2000 as its backend, and have just started getting the following error on 2 ASP.NET pages that had been working until late last week (and I don't think I made any changes to either page other than changing the user control that creates the header). Server Error in '/myApp' Application. ---------------------------------------------------------------------------- ----
5
3202
by: Kevin R | last post by:
I'm trying to update a sql database. It's modified Oledb code from an example that did work with an access database. How can I tweak my code to make it work? Thanks in advance. Kevin ====== Code error:
0
2156
by: clevsone | last post by:
I had the whole not having <enable parent paths> checked problem and once that was checked it fixed half of my issuse. I currently link to a Access database using asp from a flash site (login) , this is similar to what i'm doing flash-access, when i switched to a windows 2003 sever the link when the login field and password field are correct goes now-where. This page is where clients login to access there info in our database.. we are...
1
7931
by: amindi | last post by:
Hi, I wrote a VB6 program to read some data records from a Ms Access database and to write them into a SQL server database.(I use Ms Access 2000 and SQL server 2000).After reading each record in Access database, I update a text type datafield of that record in Access database to 'Y' (to mark the perticular record as a copied record)(The program does the updation). I tested the program several times by using a seperate copy of the same database...
0
1792
by: fniles | last post by:
I am using VB.Net 2003 and MS Access database. Sometimes when I open the database, I got the error "Unspecified error" The application validate users, when it validates users, it reads from a table in the database. I use connection pooling by opening the database in Form_Load, then everytime somebody comes in, I open the database and reads from it to validate the user. I then close the database. How can I fix this "Unspecified error" ?...
12
49416
by: ewarts | last post by:
Hey Guys, I have an access database with a few tables and forms. I was trying to add a new combo box to one of my forms and to do so i needed to add the referenced data to my reference data table. simple or so I thought, but while attempting to do so I got the following error ""database engine could not lock table because it is already in use by other " . I am currently the only user with access to this database so i'm at a lost as to how it...
1
2360
by: Brit | last post by:
I have an ASP file that retrieves names from an Access database for 4 different categories of membership, which the visitor to the page selects (corporate, institutional, regular, or student). The DNS name is "cati", the names are specified in the "Last_names" field, and the categories are in the "categories" field. l want the results sorted in alphabetic order by last name. However, the results appear to be in a totally random,...
11
5016
by: fniles | last post by:
One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application tries to read either a query or a table from the database, in in both VB6 and VB.NET applications, I got the error "The Microsoft Jet database engine cannot find the input table or query 'myTable'. Make sure it exists and that its name is spelled correctly." Also, I got the error "The...
0
9314
Oralloy
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...
1
9074
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,...
0
7953
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6634
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5947
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4464
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...
0
4725
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2520
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2110
bsmnconsultancy
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...

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.