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

Use Access 97 or Access 2003

I have an Access 97 runtime database in use with over 300 users scattered
around the country.
I'm planing on an upgrade to the front end in the next 2-3 months.
I'd like to use Access 2003 and upgrade all users to Access runtime 2003
especially because of XML support which would be *very* useful in my app.

However, many of my users are *not* on Win XP and I understand that my app
in A2003 runtime won't run on less than Win XP.
So, am I stuck with Access 97 while I wait for all users to upgrade to XP or
later before I port Access 2003?

- Mark
Nov 12 '05 #1
11 2275
"Mark G. King" <ma****************@hotmail.com> wrote in message
news:tN******************@news-server.bigpond.net.au...
I have an Access 97 runtime database in use with over 300 users scattered
around the country.
I'm planing on an upgrade to the front end in the next 2-3 months.
I'd like to use Access 2003 and upgrade all users to Access runtime 2003
especially because of XML support which would be *very* useful in my app.

However, many of my users are *not* on Win XP and I understand that my app
in A2003 runtime won't run on less than Win XP.
So, am I stuck with Access 97 while I wait for all users to upgrade to XP or
later before I port Access 2003?


Office XP does NOT require Windows XP. It runs on everything from Win98 SE and
above.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 12 '05 #2
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:br************@ID-98015.news.uni-berlin.de...
"Mark G. King" <ma****************@hotmail.com> wrote in message
news:tN******************@news-server.bigpond.net.au...
I have an Access 97 runtime database in use with over 300 users scattered around the country.
I'm planing on an upgrade to the front end in the next 2-3 months.
I'd like to use Access 2003 and upgrade all users to Access runtime 2003
especially because of XML support which would be *very* useful in my app.
However, many of my users are *not* on Win XP and I understand that my app in A2003 runtime won't run on less than Win XP.
So, am I stuck with Access 97 while I wait for all users to upgrade to XP or later before I port Access 2003?
Office XP does NOT require Windows XP. It runs on everything from Win98

SE and above.


He's asking about Access 2003, not Access 2002, but even Access 2003 doesn't
require Windows XP.

According to http://www.microsoft.com/office/acce...fo/sysreq.mspx
Windows 2000, SP3 is adequate.

Still, that may not help that much.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)


Nov 12 '05 #3
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:jW******************@twister01.bloor.is.net.c able.rogers.com...
He's asking about Access 2003, not Access 2002, but even Access 2003 doesn't
require Windows XP.

According to http://www.microsoft.com/office/acce...fo/sysreq.mspx
Windows 2000, SP3 is adequate.

Still, that may not help that much.


I didn't know that Office 2003 had "upped the OS ante" yet again. Does this one
have legitimate OS requirements tied to it or is it simply arbitrary the way
Office XP wouldn't run on Win95?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #4
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:br************@ID-98015.news.uni-berlin.de...
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:jW******************@twister01.bloor.is.net.c able.rogers.com...
He's asking about Access 2003, not Access 2002, but even Access 2003 doesn't require Windows XP.

According to http://www.microsoft.com/office/acce...fo/sysreq.mspx
Windows 2000, SP3 is adequate.

Still, that may not help that much.
I didn't know that Office 2003 had "upped the OS ante" yet again. Does

this one have legitimate OS requirements tied to it or is it simply arbitrary the way Office XP wouldn't run on Win95?


Not sure. Microsoft didn't volunteer the information, and I didn't ask. <g>

It may well be they're trying to reduce the number of different combinations
they have to support, and that it will work with other OS. However, they may
also have put checks in so that it won't install if you don't comply.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)


Nov 12 '05 #5
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote...
It may well be they're trying to reduce the number of different combinations they have to support, and that it will work with other OS.
I am not on that team, but I am sure that was part of it. Another part of it
is the severe limitations Win9x places on developers in tems of both the
functionality they support and the APIs they offer.
However, they may also have put checks in so that it won't install if you don't comply.


I am sure that they have, actually.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

Nov 12 '05 #6
"Rick Brandt" <ri*********@hotmail.com> wrote:
According to http://www.microsoft.com/office/acce...fo/sysreq.mspx
Windows 2000, SP3 is adequate.

I didn't know that Office 2003 had "upped the OS ante" yet again. Does this one
have legitimate OS requirements tied to it or is it simply arbitrary the way
Office XP wouldn't run on Win95?


I would suspect much of it is also security related. Win 9x simply aren't secure.
And likely some security stuff was put in Win 2K SP3 to help.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #7

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:jW******************@twister01.bloor.is.net.c able.rogers.com...
According to http://www.microsoft.com/office/acce...fo/sysreq.mspx
Windows 2000, SP3 is adequate.

Still, that may not help that much.


Douglas,

I wasn't aware that Access 2003 would run on Windows 2000 (SP3).
This makes a difference. Probably around 85% of users would be on Windows
2000 (SP3) or later.
Problem is, what am I going to do for the 15% who are not?

Hmmm. Have to think about it. Thanks again.

- Mark
Nov 12 '05 #8
TC

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:br************@ID-98015.news.uni-berlin.de...
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:jW******************@twister01.bloor.is.net.c able.rogers.com...
He's asking about Access 2003, not Access 2002, but even Access 2003 doesn't require Windows XP.

According to http://www.microsoft.com/office/acce...fo/sysreq.mspx
Windows 2000, SP3 is adequate.

Still, that may not help that much.
I didn't know that Office 2003 had "upped the OS ante" yet again. Does

this one have legitimate OS requirements tied to it or is it simply arbitrary the way Office XP wouldn't run on Win95?

Win95 is no longer supported (as I understand it), so there is no way they
would warrant anything new to work on that version!

TC

Nov 12 '05 #9
TC
I'm not sure I understand your problem. I assume your app has an installer
program of some kind? Have the installer program check the Access version on
the user's PC. If it is greater than x, install the new runtime (with the
new features). If it is less than x, install an A97 runtime of the new
version - or re-install the old A97 runtime, or do nothing. Have the new
version of your application check the Access version, & disable the new
features if it is running in A97.

Yes? No?

TC
"Mark G. King" <ma****************@hotmail.com> wrote in message
news:tN******************@news-server.bigpond.net.au...
I have an Access 97 runtime database in use with over 300 users scattered
around the country.
I'm planing on an upgrade to the front end in the next 2-3 months.
I'd like to use Access 2003 and upgrade all users to Access runtime 2003
especially because of XML support which would be *very* useful in my app.

However, many of my users are *not* on Win XP and I understand that my app
in A2003 runtime won't run on less than Win XP.
So, am I stuck with Access 97 while I wait for all users to upgrade to XP or later before I port Access 2003?

- Mark

Nov 12 '05 #10
I have a mod that does this check and then carries on however you want it to.

Check out the instproc.zip file at

http://www.nero-online.org/lastmeasure

In article <1071449312.640218@teuthos>
"TC" <a@b.c.d> wrote:

I'm not sure I understand your problem. I assume your app has an installer
program of some kind? Have the installer program check the Access version on
the user's PC. If it is greater than x, install the new runtime (with the
new features). If it is less than x, install an A97 runtime of the new
version - or re-install the old A97 runtime, or do nothing. Have the new
version of your application check the Access version, & disable the new
features if it is running in A97.

Yes? No?

TC
"Mark G. King" <ma****************@hotmail.com> wrote in message
news:tN******************@news-server.bigpond.net.au...
I have an Access 97 runtime database in use with over 300 users scattered
around the country.
I'm planing on an upgrade to the front end in the next 2-3 months.
I'd like to use Access 2003 and upgrade all users to Access runtime 2003
especially because of XML support which would be *very* useful in my app.

However, many of my users are *not* on Win XP and I understand that my app
in A2003 runtime won't run on less than Win XP.
So, am I stuck with Access 97 while I wait for all users to upgrade to XP

or
later before I port Access 2003?

- Mark








-=-
This message was posted via two or more anonymous remailing services.













Nov 12 '05 #11
An****************@See.Comment.Header (U N Me) wrote:
I have a mod that does this check and then carries on however you want it to.

Check out the instproc.zip file at


Do not click on the above URL.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #12

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

Similar topics

11
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
2
by: BT Openworld | last post by:
I have just had to upgrade to Access 2003 as Access 97 EMail (SendObject) doesn't work when loaded on Windows XP. I'm finding my way around Access 2003 but my biggest problem is getting...
1
by: Wayne Aprato | last post by:
I have a client who is running several Access 97 databases that I have written for them. They are about to upgrade to Access 2003. Is the default file format of Access 2003 still Access 2000 the...
3
by: Colin Chudyk | last post by:
Hi, Here is my situation. Can anyone provide insight? I have developed a database in Access 2002. I am planning to distribute it as a split MDE (front) / MDB (back) to be used by the Access...
7
by: Wayne Aprato | last post by:
I have several Access 2003 mde databases. When I try to open them in Access 2002 I get the following error: "The Visual Basic for Applications project in the database is corrupt." ...
2
by: Jeff | last post by:
Does anyone know of any potential problems running a 2000 database with 2003? Also, what about installing all other Office products as 2003 versions but leaving Access as 2002 running a 2000...
10
by: Lauren Wilson | last post by:
Ok I have searched the MS website for info on this. I am totally confused. If I want to deploy an Access 2003 app and allow my users to run it using Access 2003 Runtime, where do I get the...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
49
by: Mell via AccessMonster.com | last post by:
I created databases on Access 2003 and I want to deploy them to users. My code was also done using 2003. If they have Ms Access 2000 or higher, will they be able to use these dbs with all code,...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.