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

Installing a 2002 version DB on a A97 system

Hello
Some time ago with the help of this group I made an amateurish
database that catalogs all of our shop drawings. Works really well ( I
think) but management, in its infinite wisdom, wants a "professional"
database.
So, they have contracted out a local programmer and his first "beta"
will not run.. He coded the *.mde in Access 2002 (in spite of being
informed that we have A97). Now he wants to run an installer that will
allow us to run it??????????
Not quite sure what he means by this..........? Surely he is not going
to install Access 2002. I understand that "if" one has the developer
version of MS Access one can create a application that will run
without the program Access installed. But... I have also read (here I
think) that there are potential problems. i.e. databases that work
with A97 "may" not work after this installer is installed.

Anyone able to comment on any apprehensions I should have?

Thanks
Ralph
Nov 13 '05 #1
2 1358
This is what you need: http://www.sagekey.com/products/acc2002/wise.asp

Note that it's still not a great idea to run 2000 and above versions of Office
products on a pre-W2K system. Access is better than some, though. Excel runs
out of resources in no time, and stops redrawing parts of the screen.

On Sun, 08 Aug 2004 02:46:45 GMT, Ralph2 <no*******@hotmail.com> wrote:
Hello
Some time ago with the help of this group I made an amateurish
database that catalogs all of our shop drawings. Works really well ( I
think) but management, in its infinite wisdom, wants a "professional"
database.
So, they have contracted out a local programmer and his first "beta"
will not run.. He coded the *.mde in Access 2002 (in spite of being
informed that we have A97). Now he wants to run an installer that will
allow us to run it??????????
Not quite sure what he means by this..........? Surely he is not going
to install Access 2002. I understand that "if" one has the developer
version of MS Access one can create a application that will run
without the program Access installed. But... I have also read (here I
think) that there are potential problems. i.e. databases that work
with A97 "may" not work after this installer is installed.

Anyone able to comment on any apprehensions I should have?

Thanks
Ralph


Nov 13 '05 #2
The Office XP Developer Edition includes Runtime Support so that the
application can be run by users who do not have Access 2002 installed. Be
aware that, if done properly, this can work very well without significant
problems; if not done properly, it can be problematical. There _are_
limitations when using the runtime.

Installing the Access 2000 runtime could break existing Access 97
applications. I am not certain if that was fixed with any of the Service
Releases or in Access 2002. Before I let anyone install a later version of
the runtime support on a machine of mine that had useful Access 97
applications, I'd make certain sure by installing A97 and those applications
on another machine using the same OS, and trying it out. If I'd told the
developer that I wanted an application for Access 97, I wouldn't accept one
that required a different version even if it came with the runtime.

I guess I would just have one question... only as a matter of interest,
because I'm certainly not a lawyer and I don't have any idea what might be
involved in pursuing a legal solution. That question would be: you said you
had told the developer that you had Access 97 installed, but did anyone say
anything about Access 2002 or the Access 2002 runtime support?

Did your contract with this developer call for him to deliver "source code"?
An .MDE is not source code -- none of the code, forms, or reports can be
opened in design view and changed. If you are to get the source, so you can
maintain it in the future, either yourself or by hiring some other
contractor, be sure you get the .MDB. If your contract allowed the developer
to deliver an .MDE, you are in the proverbial pickle because no one else
will be able to fix or enhance what you have -- you'll have to go back to
him.

It is always (can I repeat for emphasis, shouting? ALWAYS) a good idea to
have a contract, drawn up by your attorney, for computer work done "out of
house". In fact, it is _folly_ not to have one.

Larry Linson

"Ralph2" <no*******@hotmail.com> wrote in message
news:ve********************************@4ax.com...
Hello
Some time ago with the help of this group I made an amateurish
database that catalogs all of our shop drawings. Works really well ( I
think) but management, in its infinite wisdom, wants a "professional"
database.
So, they have contracted out a local programmer and his first "beta"
will not run.. He coded the *.mde in Access 2002 (in spite of being
informed that we have A97). Now he wants to run an installer that will
allow us to run it??????????
Not quite sure what he means by this..........? Surely he is not going
to install Access 2002. I understand that "if" one has the developer
version of MS Access one can create a application that will run
without the program Access installed. But... I have also read (here I
think) that there are potential problems. i.e. databases that work
with A97 "may" not work after this installer is installed.

Anyone able to comment on any apprehensions I should have?

Thanks
Ralph

Nov 13 '05 #3

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

Similar topics

2
by: Ken Lindner | last post by:
I have a need to become familiar with SQL Server 2000 for work. Needless to say I am new to SQL Server any version, but not IT in general. My employer has provided me with the SQL Server 2000...
0
by: Ricardo Dias Marques | last post by:
Hi, I have a development machine with Visual Studio .Net 2003 which, as far as I know, targets the 1.1 .Net Framework. Now I need to open some solutions that were created in another machine...
0
by: blegs38552 | last post by:
My computer currently has Visual C++ .NET Standard 2003 installed in Windows XP Home Edition, running inside of Microsoft Visual Studio .NET 2003. I recently acquired Visual Basic.net Standard...
7
by: Adam | last post by:
Im trying to add an httphandler for all *.sgf file extensions. I have developed the handler, 1. installed it into the gac 2. added it to the machine.config: <httpHandlers> <add verb="*"...
11
by: tshad | last post by:
I have a small Windows Service program that just has a timer on it and it built fine. I try to install it using InstallUtil and I get the following message: ...
2
by: J | last post by:
hi, I'm having a problem installing a service created in vb.net 2003 on a windows 2000 server. I have installed the service on a few XP machines with out any problems...but the 2 servers (win...
5
by: Josef Brunner | last post by:
Hi everybody, I tried to publich my application to a simple file location. (no online publishing or anything like that.) Running the setup that VS generates for me works fine on my machine...
11
by: Don | last post by:
QUESTIONS: 1. Has anyone figured out how to successfully install the Office 97 Pro Service Release 2 patch in Vista? 2. Has anyone successfully installed an Office 97 Pro CD (SR2 version) in...
0
by: Peter Van Peborgh | last post by:
I have an app that is built in Access 2002 and packaged with its runtime. When installing it in a Vista PC/laptop, several dialog boxes pop up that require specific answers for the app to install and...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
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
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
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: 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)...

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.