[mso] Re: Access Developers edition- which one?
- From: "Colli, Anthony G" <Anthony.Colli@xxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 17 Jul 2003 10:21:26 -0400
Alan-
When developing an executable there are many variables to consider. The client
might have win98 today but not next year or even next week! As Ray says all the
Access runtimes run on all systems but they carry with them different version
of MDAC. This can vary from what the client has. It usually doesn't cause
problems but it can. If your going to use wrap it all up with an installer
package that does the install, DO NOT USE THE ONE IN THE DEVELOPER EDITION it
has problems. Get a third party install package, Wise is a good one.
All the code needs to be checked, double checked, and then checked again. It
should have proper error handling in all forms and modules. Users should never
encounter a runtime error that kills the executables process.
Most data entered should be verified against a source (look up table, list) or
in code (regular expression, input mask). This can't always be done, but you
can check for errant alpha characters in numeric data types and so on. The
database will generate an error on update, but ideally you want to trap the
error way before that.
If the database requirements change over time you need to think about
versioning and migration of the existing data to the new version of the
application. An executable is just that, if the client needs a different report
in the application, it can possible mean a completely new version of the
application.
-Anthony
-----Original Message-----
From: Ray Blake [ mailto:ray@xxxxxxxxx]
Sent: Thursday, July 17, 2003 8:46 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access Developers edition- which one?
Alan,
The quick answer is 'Yes'. I've checked the system requirements for
Office XP Developer Edition, and Windows 98 is supported. There's no
reason why you can't deploy your 2000 or XP app to them packaged with a
current runtime version. When you get the Developer's edition, you'll
find the manual (yes, a real paper one!) has a whole section on
deploying apps with the Access runtime. I've just looked over it, and
there's nothing there that prevents you doing what you want to.
Ray Blake
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [ mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Alan Forster
Sent: 17 July 2003 13:22
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access Developers edition- which one?
Hello,
I have several years experience of developing access databases from 97
and more recently in 2000. In all cases the databases have been
designed for me or a colleague to use. We then give reports in pdf
format or Excel to our Clients, rarely (very rarely) we hand over a
database file. Normally the reason we do not hand it over is the speed
we develop at is such the database is not polished (at all). We are
normally developing to solve a problem that needs an answer yesterday
and the answer is all that matters. We do not add very much error
handling or data checks for user entry etc.
Our Client has now asked us to develop a peice of 'software' that we
hand over to them that allows them to continue asking and answering the
questions once the initial stage of analysis is finished- great from our
point of view as we have follow on work.
My problem is that they want it developed in Access 97 because they run
Windows 98. We need to give them a run-time version of the software and
therefore need a developers edition. Not having used the developers
editions before and only able to find a price for XP Developer we need
to know if we can develop an application for other versions of Windows
using the XP developers edition. Ideally I would like to develop the
application in A2000 or 2002 and hand it over as a run-time application.
Will this run on Windows 98?
Any input/thoughts will be appreciated,
Thanks,
Alan.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
