473,836 Members | 1,545 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Upgrading to Office 2003

Hi,

I have to upgrade a number of databases from Access 2.0, Access 97 and
Access 2000 to work in Office 2003. These databases contain a number
of Forms coded with VBA as well as a number of Queries/Macros.

The Microsoft web site says that Office 2003 will open databases
created in these versions.

However i have in the past upgraded databases from access 2.0 to 97
and have encountered problems with the VBA code, and i have used the
built in tools for some simple databases to upgrade to 2000 from 97
but these ones are more complex so i may not have encountered all the
problems, and i have never upgraded to Office 2003

Does anyone know of any issues with upgrading from these version's to
Office 2003

Thanks in Advance

Aidan Tobin
Nov 12 '05 #1
11 1940
Aidan Tobin wrote:
Hi,

I have to upgrade a number of databases from Access 2.0, Access 97 and
Access 2000 to work in Office 2003. These databases contain a number
of Forms coded with VBA as well as a number of Queries/Macros.

The Microsoft web site says that Office 2003 will open databases
created in these versions.

However i have in the past upgraded databases from access 2.0 to 97
and have encountered problems with the VBA code, and i have used the
built in tools for some simple databases to upgrade to 2000 from 97
but these ones are more complex so i may not have encountered all the
problems, and i have never upgraded to Office 2003

Does anyone know of any issues with upgrading from these version's to
Office 2003

Thanks in Advance

Aidan Tobin


2002/2003 still can use the 2000 file format so why do you need to
convert? :)
--
regards,

Bradley
Nov 12 '05 #2
On 21 Apr 2004 11:52:53 -0700, ai********@hotm ail.com (Aidan Tobin)
wrote:

From Access 2 to any other version can be a major step, since you're
going from 16-bit to 32-bit. Perhaps it makes sense to settle on the
Access2000 format: it is still supported by the newer versions.

-Tom.

Hi,

I have to upgrade a number of databases from Access 2.0, Access 97 and
Access 2000 to work in Office 2003. These databases contain a number
of Forms coded with VBA as well as a number of Queries/Macros.

The Microsoft web site says that Office 2003 will open databases
created in these versions.

However i have in the past upgraded databases from access 2.0 to 97
and have encountered problems with the VBA code, and i have used the
built in tools for some simple databases to upgrade to 2000 from 97
but these ones are more complex so i may not have encountered all the
problems, and i have never upgraded to Office 2003

Does anyone know of any issues with upgrading from these version's to
Office 2003

Thanks in Advance

Aidan Tobin


Nov 12 '05 #3
Oh how i wish i could but someone dosent see it that way, All
databases have to be upgraded to office 2003...
Nov 12 '05 #4
Aidan Tobin wrote:
Oh how i wish i could but someone dosent see it that way, All
databases have to be upgraded to office 2003...


Hehe, sounds like one of my clients;) God bless 'em.

There shouldn't be any major dramas converting 2000-2003 except the
annoyance of Digital Signatures in 2003.
--
regards,

Bradley
Nov 12 '05 #5
ai********@hotm ail.com (Aidan Tobin) wrote in
news:67******** *************** **@posting.goog le.com:
Oh how i wish i could but someone dosent see it that way, All
databases have to be upgraded to office 2003...


Do they really understand that the Access 2000 format is native to
Access 2003?

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #6
David W. Fenton wrote:
ai********@hotm ail.com (Aidan Tobin) wrote in
news:67******** *************** **@posting.goog le.com:

Oh how i wish i could but someone dosent see it that way, All
databases have to be upgraded to office 2003...

Do they really understand that the Access 2000 format is native to
Access 2003?


But he has v2.0 and 97 databases to upgrade as well, and there may be
issues upgrading them.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer
Nov 12 '05 #7
Trevor Best <nospam@localho st> wrote in
news:40******** *************** @auth.uk.news.e asynet.net:
David W. Fenton wrote:
ai********@hotm ail.com (Aidan Tobin) wrote in
news:67******** *************** **@posting.goog le.com:
Oh how i wish i could but someone dosent see it that way, All
databases have to be upgraded to office 2003...


Do they really understand that the Access 2000 format is native
to Access 2003?


But he has v2.0 and 97 databases to upgrade as well, and there may
be issues upgrading them.


But upgrading to A2K3 format seems to me to be a mistake. Upgrading
to A2K format maintains backward compatibility with the last three
releases of Access, while losing you nothing but a small handful of
features specific to A2K2 and A2K3.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #8
David W. Fenton wrote:
Trevor Best <nospam@localho st> wrote in
news:40******** *************** @auth.uk.news.e asynet.net:

David W. Fenton wrote:
ai********@h otmail.com (Aidan Tobin) wrote in
news:67***** *************** *****@posting.g oogle.com:
Oh how i wish i could but someone dosent see it that way, All
databases have to be upgraded to office 2003...

Do they really understand that the Access 2000 format is native
to Access 2003?


But he has v2.0 and 97 databases to upgrade as well, and there may
be issues upgrading them.

But upgrading to A2K3 format seems to me to be a mistake. Upgrading
to A2K format maintains backward compatibility with the last three
releases of Access, while losing you nothing but a small handful of
features specific to A2K2 and A2K3.


He would still have to upgrade his 2.0 & 97 databases to 2000 format to
avoid all the dialogs and long load times of opening such in either 2K,
2K2 or 2K3.

Maintaining backward compatibility with 2000 would negate the point of
having the latest version although as you say, there's not much more to
it, the only significant things I've seen added to 2K3 are unproductive,
e.g. warnings about macros, etc. they might as well place a warning
within the executable itself that says "warning: this executable file
contains executable code that may damage your computer, are you sure you
want to run it?".

I think MS has gone too far on this one and 2K2 will be the last version
I'll ever use.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer
Nov 12 '05 #9
Trevor Best <nospam@localho st> wrote in
news:40******** *************** @auth.uk.news.e asynet.net:
David W. Fenton wrote:
Trevor Best <nospam@localho st> wrote in
news:40******** *************** @auth.uk.news.e asynet.net:
David W. Fenton wrote:

ai********@ hotmail.com (Aidan Tobin) wrote in
news:67**** *************** ******@posting. google.com:
>Oh how i wish i could but someone dosent see it that way, All
>database s have to be upgraded to office 2003...

Do they really understand that the Access 2000 format is native
to Access 2003?

But he has v2.0 and 97 databases to upgrade as well, and there
may be issues upgrading them.
But upgrading to A2K3 format seems to me to be a mistake.
Upgrading to A2K format maintains backward compatibility with the
last three releases of Access, while losing you nothing but a
small handful of features specific to A2K2 and A2K3.


He would still have to upgrade his 2.0 & 97 databases to 2000
format to avoid all the dialogs and long load times of opening
such in either 2K, 2K2 or 2K3.


Naturally. But the question is whether to upgrade to the absolute
latest format or to one that's cross-version compatible. Seems like
a no-brainer to me, especially since upgraded MDBs couldn't possibly
be using any of the features possible only in the post-A2K file
formats.
Maintaining backward compatibility with 2000 would negate the
point of having the latest version although as you say, there's
not much more to it, the only significant things I've seen added
to 2K3 are unproductive, e.g. warnings about macros, etc. they
might as well place a warning within the executable itself that
says "warning: this executable file contains executable code that
may damage your computer, are you sure you want to run it?".

I think MS has gone too far on this one and 2K2 will be the last
version I'll ever use.


I think the fact that they have settled on a base format that they
support in all versions is a very good thing. It looks like an
advantage that means you could get by without having to upgrade
everyone just because you can no longer purchase new machines with
the version 1 or 2 behind the currently selling ones (assuming you
don't have a site license, of course, as none of my clients do,
since they are all too small to justify it).

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #10

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

Similar topics

5
512
by: Mike Owen | last post by:
Hi, I have just used the import Wizard to import a VS 2003 app to VS 2005. I have a lot of work to do to enable it to compile successfully with all the errors and warnings it gave me, but as a starting point the compiler can no longer find the function as at the bottom of this posting, that was in the Global.asax.vb file. All the function does is give an easy / quick way of getting the application
13
2658
by: Noesis Strategy | last post by:
When I ordered my new laptop, Sony didn't offer Access 2003 in its bundles. Recently, I have begun to design Access databases using an copy of Access 2002 from my previous laptop. It works fine, but I would like to have all the office apps on the same version. So I have a few questions: 1) Is the file format the same as 2002? Can 2002 users read 2003 files? 2) What are the major reasons for upgrading to 2002 ?
11
1316
by: Aidan Tobin | last post by:
Hi, I have to upgrade a number of databases from Access 2.0, Access 97 and Access 2000 to work in Office 2003. These databases contain a number of Forms coded with VBA as well as a number of Queries/Macros. The Microsoft web site says that Office 2003 will open databases created in these versions. However i have in the past upgraded databases from access 2.0 to 97
7
1706
by: John | last post by:
Hi I have an old access 97 application which I need to upgrade to one of the newer versions. Which of the access versions xp or 2003 should I choose? Which one is more stable? Thanks Regards
2
1822
by: Lauren Wilson | last post by:
Hi Folks, I have a widely distributed Access 200 Application. I must retain my ability to support users who are still on Access 2000 and Access 2000 Runtime. However I also need to upgrade my development environment to Office 2003 Professional. My question is: Where can I find a comprehensive description of the known issues that will affect my ability to do all of the above after I upgrade my own development environment to Office...
17
2075
by: Owen Jenkins | last post by:
I have an Access application that is being used by 150+ clients. I develop in 97, convert to 2000 and distribute as a 97 or 2000 mde, or 97 runtime. This limits me to 97 functions. My clients may use any one of Access 97, 2000, 2002, 2003 or 97 runtime. So that I'm not lingering too far behind, I'm thinking of developing in 2003, using 2000 file format and distributing a 2000 mde for users of Access 2000+. (I understand I'll need to use...
3
2267
by: ARC | last post by:
Hello All, I have a major application for quoting and invoicing that is written in Access 97 (both front and back ends). I have a user base of over 300 customers, and currently I don't require that they have Access 97, as I use the access 97 runtime scripts from Sagekey software. The main problems I've seen with Access 97 are the built in e-mail support for sending reports. Unless a user uses the MS Outlook 2000/XP method, they have to...
14
2789
by: ARC | last post by:
Hello All, I have a major application for quoting and invoicing that is written in Access 97 (both front and back ends). I have a user base of over 300 customers, and currently I don't require that they have Access 97, as I use the access 97 runtime scripts from Sagekey software. The main problems I've seen with Access 97 are the built in e-mail support for sending reports. Unless a user uses the MS Outlook 2000/XP method, they have to...
0
9827
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10560
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10262
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7798
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6986
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5662
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5838
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4468
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
2
4033
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.