Guest Chris Barnes Posted September 23, 2008 Posted September 23, 2008 A google search of this topic showed some discussions of this exact problem, but nothing about how to actually solve the problem. I have a user who needs to run Access97 on their brand new Vista computer (Enterprise - but I don't think that matters). At the end of the installation (setup.exe run as Administrator), I get an error that says "an error occurred at changing the workgroup database SETUP couldn't create a system.mdw file. Reboot your computer and run Workgroup Administrator before you run the application" So I did that (as Administrator). Nada. Copied a System.mdw file from another machine and put it in a directory called "C:\Apps\Office97Extras\" and pointed to it using Workgroup Admin. Still nada. I am officially out of ideas. Anyone else? Anyone? Bueller? (I looked for an Access newsgroup to post this to, but none of them seemed appropriate for this question) -- + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Chris Barnes AOL IM: CNBarnes chris-barnes@tamu.edu Yahoo IM: chrisnbarnes Quote
Guest Paul Montgomery Posted September 23, 2008 Posted September 23, 2008 On Tue, 23 Sep 2008 12:00:57 -0500, Chris Barnes <chris-barnes@tamu.edu> wrote: <span style="color:blue"> >A google search of this topic showed some discussions of this exact >problem, but nothing about how to actually solve the problem.</span> http://accessblog.net/2007/06/access-97-on-vista.html <span style="color:blue"> >I have a user who needs to run Access97 on their brand new Vista >computer (Enterprise - but I don't think that matters). At the end of >the installation (setup.exe run as Administrator), I get an error that says > "an error occurred at changing the workgroup database > SETUP couldn't create a system.mdw file. Reboot your computer and > run Workgroup Administrator before you run the application" > >So I did that (as Administrator). > >Nada. > >Copied a System.mdw file from another machine and put it in a directory >called "C:AppsOffice97Extras" and pointed to it using Workgroup Admin. > >Still nada. > > > >I am officially out of ideas. Anyone else? Anyone? Bueller? > > >(I looked for an Access newsgroup to post this to, but none of them >seemed appropriate for this question)</span> Quote
Guest DL Posted September 23, 2008 Posted September 23, 2008 Try cross post to an Access group "Chris Barnes" <chris-barnes@tamu.edu> wrote in message news:%23gi5%233ZHJHA.1940@TK2MSFTNGP03.phx.gbl...<span style="color:blue"> >A google search of this topic showed some discussions of this exact >problem, but nothing about how to actually solve the problem. > > I have a user who needs to run Access97 on their brand new Vista computer > (Enterprise - but I don't think that matters). At the end of the > installation (setup.exe run as Administrator), I get an error that says > "an error occurred at changing the workgroup database > SETUP couldn't create a system.mdw file. Reboot your computer and > run Workgroup Administrator before you run the application" > > So I did that (as Administrator). > > Nada. > > Copied a System.mdw file from another machine and put it in a directory > called "C:AppsOffice97Extras" and pointed to it using Workgroup Admin. > > Still nada. > > > > I am officially out of ideas. Anyone else? Anyone? Bueller? > > > (I looked for an Access newsgroup to post this to, but none of them seemed > appropriate for this question) > > -- > > + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + > Chris Barnes AOL IM: CNBarnes > chris-barnes@tamu.edu Yahoo IM: chrisnbarnes </span> Quote
Guest Paul Montgomery Posted September 23, 2008 Posted September 23, 2008 On Tue, 23 Sep 2008 20:04:11 +0100, "DL" <address@invalid> wrote: <span style="color:blue"> >Try cross post to an Access group</span> Reading is a skill, DL (Dim Lamp?): <span style="color:blue"><span style="color:green"> >> (I looked for an Access newsgroup to post this to, but none of them seemed >> appropriate for this question)</span></span> Quote
Guest DDW Posted September 23, 2008 Posted September 23, 2008 On Tue, 23 Sep 2008 20:04:11 +0100, "DL" <address@invalid> wrote: <span style="color:blue"> >Try cross post to an Access group</span> The OP looked for an appropriate Access group already and didn't find one. DDW -- Reply via this group No email please Quote
Guest Beoweolf Posted September 23, 2008 Posted September 23, 2008 Did you check to see if Access 97 is compatible with Vista? The fact that it shows an error related to \system files could be a hint that it may be time to update your application to something slightly more current. Access 97, obviously, is several iterations below Access 2007, in software years - that is ancient. Have you tried the "compatibility setting". I think you did, but had to bring it up. Under compatibility I think there is setting which makes suggestions on how to apply "shims" which you can use to fool the OS into allowing the app to run? If that didn't work - you may be able to do a a step migration. Install an intermediate version of access, see if you can convert the program to run under something like access 2000 or 2003 - then import it into access 2007. Waiting is not always the best thing to do when it comes to custom applications minus code. Not ragging on you you, just restating the obvious. "Chris Barnes" <chris-barnes@tamu.edu> wrote in message news:%23gi5%233ZHJHA.1940@TK2MSFTNGP03.phx.gbl...<span style="color:blue"> >A google search of this topic showed some discussions of this exact >problem, but nothing about how to actually solve the problem. > > I have a user who needs to run Access97 on their brand new Vista computer > (Enterprise - but I don't think that matters). At the end of the > installation (setup.exe run as Administrator), I get an error that says > "an error occurred at changing the workgroup database > SETUP couldn't create a system.mdw file. Reboot your computer and > run Workgroup Administrator before you run the application" > > So I did that (as Administrator). > > Nada. > > Copied a System.mdw file from another machine and put it in a directory > called "C:AppsOffice97Extras" and pointed to it using Workgroup Admin. > > Still nada. > > > > I am officially out of ideas. Anyone else? Anyone? Bueller? > > > (I looked for an Access newsgroup to post this to, but none of them seemed > appropriate for this question) > > -- > > + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + > Chris Barnes AOL IM: CNBarnes > chris-barnes@tamu.edu Yahoo IM: chrisnbarnes </span> Quote
Guest Beoweolf Posted September 23, 2008 Posted September 23, 2008 try installing virtual PC 2007 on your vista system. Create a downgraded PC, then install and run your application in that virtual OSE. "Chris Barnes" <chris-barnes@tamu.edu> wrote in message news:%23gi5%233ZHJHA.1940@TK2MSFTNGP03.phx.gbl...<span style="color:blue"> >A google search of this topic showed some discussions of this exact >problem, but nothing about how to actually solve the problem. > > I have a user who needs to run Access97 on their brand new Vista computer > (Enterprise - but I don't think that matters). At the end of the > installation (setup.exe run as Administrator), I get an error that says > "an error occurred at changing the workgroup database > SETUP couldn't create a system.mdw file. Reboot your computer and > run Workgroup Administrator before you run the application" > > So I did that (as Administrator). > > Nada. > > Copied a System.mdw file from another machine and put it in a directory > called "C:AppsOffice97Extras" and pointed to it using Workgroup Admin. > > Still nada. > > > > I am officially out of ideas. Anyone else? Anyone? Bueller? > > > (I looked for an Access newsgroup to post this to, but none of them seemed > appropriate for this question) > > -- > > + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + > Chris Barnes AOL IM: CNBarnes > chris-barnes@tamu.edu Yahoo IM: chrisnbarnes </span> Quote
Guest Gordon Posted September 24, 2008 Posted September 24, 2008 "Chris Barnes" <chris-barnes@tamu.edu> wrote in message news:%23gi5%233ZHJHA.1940@TK2MSFTNGP03.phx.gbl...<span style="color:blue"> >A google search of this topic showed some discussions of this exact >problem, but nothing about how to actually solve the problem. > > I have a user who needs to run Access97 on their brand new Vista computer > (Enterprise - but I don't think that matters). At the end of the > installation (setup.exe run as Administrator), I get an error that says > "an error occurred at changing the workgroup database > SETUP couldn't create a system.mdw file. Reboot your computer and > run Workgroup Administrator before you run the application" > > So I did that (as Administrator). > > Nada. > > Copied a System.mdw file from another machine and put it in a directory > called "C:AppsOffice97Extras" and pointed to it using Workgroup Admin. > > Still nada. > > > > I am officially out of ideas. Anyone else? Anyone? Bueller? ></span> I would rather use Open Office Base (v 2.4 I think is current) than something that is THAT old..... Quote
Guest Chris Barnes Posted September 24, 2008 Posted September 24, 2008 DL wrote:<span style="color:blue"> > Try cross post to an Access group > <span style="color:green"> >> (I looked for an Access newsgroup to post this to, but none of them seemed >> appropriate for this question)</span></span> Reading all the way to the end of the OP would be helpful... -- + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Chris Barnes AOL IM: CNBarnes chris-barnes@tamu.edu Yahoo IM: chrisnbarnes Quote
Guest Chris Barnes Posted September 24, 2008 Posted September 24, 2008 Beoweolf wrote:<span style="color:blue"> > Did you check to see if Access 97 is compatible with Vista? The fact that it > shows an error related to system files could be a hint that it may be time > to update your application to something slightly more current. Access 97, > obviously, is several iterations below Access 2007, in software years - that > is ancient.</span> A few years ago my wife and I bought some land and began building a house we had been dreaming of for 20+ years. We were very involved in every step of the process, doing ALOT of the work ourselves. But, not being professional construction homebuilders, we still hired a professional contractor to oversee everything (including the work we did). His name was Jay. We became pretty good friends during the process. During the building, my wife would often ask "can we do such-and-such". Jay always had the same answer: "Sure. All it takes it money". So it is with upgrading custom apps written in Access 97. Could it be updated to run in Access 2000,2002,2003,2007? Sure - all it would take is the money to pay the programmers. And for a program that ran "just fine" as it was, it just didn't make alot of sense to spend that money when we didn't have to. For the record, the entire app is being replaced (with QuickBooks - which tells you what kind of app it is/was). But we still need to be able to get into it for historical reasons. All this to simply say this: if you can't answer the question being asked (as others were able to do), keep your fingers off the keyboard. -- + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Chris Barnes AOL IM: CNBarnes chris-barnes@tamu.edu Yahoo IM: chrisnbarnes Quote
Guest Chris Barnes Posted September 24, 2008 Posted September 24, 2008 Answering my own question, since I found a way to do it (1) Install somewhere OTHER than into the default location. I installed to C:\Apps\MSOffice97 (2) Edit the properties of the folder (I did the entire C:\Apps) such that USERS have FULL CONTROL (3) copy the system.mdw file to this location and point to it using Workgroup Admin (4) install SP2 and Jet3.5 (to solve the "Out of Memory" problem which is what next comes up). Done. Now Access 97 happily runs on Vista. -- + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Chris Barnes AOL IM: CNBarnes chris-barnes@tamu.edu Yahoo IM: chrisnbarnes Quote
Guest Paul Adare - MVP Posted September 24, 2008 Posted September 24, 2008 On Wed, 24 Sep 2008 15:54:30 -0500, Chris Barnes wrote: <span style="color:blue"> > DL wrote:<span style="color:green"> >> Try cross post to an Access group >> <span style="color:darkred"> >>> (I looked for an Access newsgroup to post this to, but none of them seemed >>> appropriate for this question)</span></span> > > > Reading all the way to the end of the OP would be helpful...</span> Just as reading all posts in a thread would be in your case. You're now the 3rd person to state exactly the same thing. -- Paul Adare MVP - Identity Lifecycle Manager http://www.identit.ca If at first you don't succeed, you must be a programmer. Quote
Guest Beoweolf Posted September 25, 2008 Posted September 25, 2008 The important thing is your satisfaction with the answer. My mistake was in thinking that you didn't know the answer for the question you asked. Obviously this is your hobby and your sole purpose was to solicit requests and critique them based on some nebulous suitability index that only you know. Fortunately, now I know too. "Chris Barnes" <chris-barnes@tamu.edu> wrote in message news:eGJyujoHJHA.3736@TK2MSFTNGP06.phx.gbl...<span style="color:blue"> > Beoweolf wrote:<span style="color:green"> >> Did you check to see if Access 97 is compatible with Vista? The fact that >> it shows an error related to system files could be a hint that it may be >> time to update your application to something slightly more current. >> Access 97, obviously, is several iterations below Access 2007, in >> software years - that is ancient.</span> > > A few years ago my wife and I bought some land and began building a house > we had been dreaming of for 20+ years. We were very involved in every > step of the process, doing ALOT of the work ourselves. But, not being > professional construction homebuilders, we still hired a professional > contractor to oversee everything (including the work we did). His name > was Jay. We became pretty good friends during the process. > > > During the building, my wife would often ask "can we do such-and-such". > > Jay always had the same answer: "Sure. All it takes it money". > > > So it is with upgrading custom apps written in Access 97. Could it be > updated to run in Access 2000,2002,2003,2007? Sure - all it would take > is the money to pay the programmers. And for a program that ran "just > fine" as it was, it just didn't make alot of sense to spend that money > when we didn't have to. > > > For the record, the entire app is being replaced (with QuickBooks - > which tells you what kind of app it is/was). But we still need to be able > to get into it for historical reasons. > > All this to simply say this: if you can't answer the question being asked > (as others were able to do), keep your fingers off the keyboard. > > -- > > + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + > Chris Barnes AOL IM: CNBarnes > chris-barnes@tamu.edu Yahoo IM: chrisnbarnes </span> Quote
Guest Paul Montgomery Posted September 25, 2008 Posted September 25, 2008 On Thu, 25 Sep 2008 09:36:34 -0700, "Beoweolf" <zenner@zenner-assc.com> wrote: <span style="color:blue"> >The important thing is your satisfaction with the answer. My mistake was in >thinking that you didn't know the answer for the question you asked. </span> And in not knowing that he is a pretentious, pompous ass when he perceives someone is questioning his knowledge. <span style="color:blue"> >Obviously this is your hobby and your sole purpose was to solicit requests >and critique them based on some nebulous suitability index that only you >know. Fortunately, now I know too. > > >"Chris Barnes" <chris-barnes@tamu.edu> wrote in message >news:eGJyujoHJHA.3736@TK2MSFTNGP06.phx.gbl...<span style="color:green"> >> Beoweolf wrote:<span style="color:darkred"> >>> Did you check to see if Access 97 is compatible with Vista? The fact that >>> it shows an error related to system files could be a hint that it may be >>> time to update your application to something slightly more current. >>> Access 97, obviously, is several iterations below Access 2007, in >>> software years - that is ancient.</span> >> >> A few years ago my wife and I bought some land and began building a house >> we had been dreaming of for 20+ years. We were very involved in every >> step of the process, doing ALOT of the work ourselves. But, not being >> professional construction homebuilders, we still hired a professional >> contractor to oversee everything (including the work we did). His name >> was Jay. We became pretty good friends during the process. >> >> >> During the building, my wife would often ask "can we do such-and-such". >> >> Jay always had the same answer: "Sure. All it takes it money". >> >> >> So it is with upgrading custom apps written in Access 97. Could it be >> updated to run in Access 2000,2002,2003,2007? Sure - all it would take >> is the money to pay the programmers. And for a program that ran "just >> fine" as it was, it just didn't make alot of sense to spend that money >> when we didn't have to. >> >> >> For the record, the entire app is being replaced (with QuickBooks - >> which tells you what kind of app it is/was). But we still need to be able >> to get into it for historical reasons. >> >> All this to simply say this: if you can't answer the question being asked >> (as others were able to do), keep your fingers off the keyboard. >> >> -- >> >> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + >> Chris Barnes AOL IM: CNBarnes >> chris-barnes@tamu.edu Yahoo IM: chrisnbarnes </span></span> Quote
Guest henri Posted September 28, 2008 Posted September 28, 2008 Hi It probably is a stupid question but what is SP2 and where can I find it, and where can I find the jet upgrade. I got to point 3 of CHris solution, but as you see I fail the knowledge to solve the stupid out of memory message -- henri Posted via http://www.vistaheads.com Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.