473,574 Members | 2,595 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 16412
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...
3
8818
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
3198
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
2153
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...
1
7897
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...
0
1781
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...
12
49372
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...
1
2356
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...
11
5002
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...
0
7814
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7736
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...
1
7826
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...
0
8107
tracyyun
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...
0
6464
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...
0
5307
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...
0
3756
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2252
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
0
1071
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...

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.