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

Convert A97 to A2000 or A2002 ?

Hello Group.

I work for a company who is about to embark on a long awaited Office upgrade
from Office 97 to Office XP.

Office XP comes with Access 2002.
I am an accomplished Access developer so I have read up on the complexities
of upgrade in the corporate environment.
Also the need to carry out a full MDB audit to get rid of the redundancy etc
etc

My specific question is this ....
We have thousands of user built databases that I want to automatically
convert from Access97 but I cant get a clear answer from the interweb as to
which format to convert to (Access 2000 or Access 2002).

We do not have any Access2000 users, so can I leap from A97 to A2002 ?
or should I do a staged upgrade A97 to A2000. Let the dust settle, then
convert A2000 to A2002.
your advise is greatly appreciated.
kind regards
tombsy
Jan 7 '07 #1
6 2198
Hi, Tombsy.
We do not have any Access2000 users, so can I leap from A97 to A2002 ?
Yes.
or should I do a staged upgrade A97 to A2000. Let the dust settle, then
convert A2000 to A2002.
The time and effort to do two conversions and test them probably isn't worth
it. While Access 2000 database format files can be opened in Access 2000
and later, making them practically universal, if you plan to distribute MDE
files, then you'll have to convert to Access 2002 database format before
creating the MDE. In addition, Access 2002 has a few features that Access
2000 doesn't, so I'd suggest converting to Access 2002 database format.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"tombsy" <ic************@tiscali.co.ukwrote in message
news:45**********@mk-nntp-2.news.uk.tiscali.com...
Hello Group.

I work for a company who is about to embark on a long awaited Office
upgrade from Office 97 to Office XP.

Office XP comes with Access 2002.
I am an accomplished Access developer so I have read up on the
complexities of upgrade in the corporate environment.
Also the need to carry out a full MDB audit to get rid of the redundancy
etc etc

My specific question is this ....
We have thousands of user built databases that I want to automatically
convert from Access97 but I cant get a clear answer from the interweb as
to which format to convert to (Access 2000 or Access 2002).

We do not have any Access2000 users, so can I leap from A97 to A2002 ?
or should I do a staged upgrade A97 to A2000. Let the dust settle, then
convert A2000 to A2002.
your advise is greatly appreciated.
kind regards
tombsy

Jan 7 '07 #2
tombsy wrote:
>I work for a company who is about to embark on a long awaited Office upgrade
from Office 97 to Office XP.

Office XP comes with Access 2002.
I am an accomplished Access developer so I have read up on the complexities
of upgrade in the corporate environment.
Also the need to carry out a full MDB audit to get rid of the redundancy etc
etc

My specific question is this ....
We have thousands of user built databases that I want to automatically
convert from Access97 but I cant get a clear answer from the interweb as to
which format to convert to (Access 2000 or Access 2002).

We do not have any Access2000 users, so can I leap from A97 to A2002 ?
or should I do a staged upgrade A97 to A2000. Let the dust settle, then
convert A2000 to A2002.

If you have no A2K users, then definitely skip A2000 and go
directly to A2003.

I have had no trouble just letting Access do its automatic
conversion of several A97 apps. Maybe my apps don't use
anything that has a problem and others have different
experiences, but I recommend that you try it before worrying
about imaginary problems.

--
Marsh
Jan 7 '07 #3
tombsy wrote:
We have thousands of user built databases that I want to automatically
convert from Access97
When the users open them in 2002 they'll be given the choice of
converting them or just using them in their current format. If they
choose conversion it will be to a new file so the old will live on
safely; that is they can choose to convert MyMDB to MyMDB2002 and both
files will continue to exist.

You might want to encourage or remind or direct them not to delete the
old 97 version and you may want to provide them with some kind of
archiving procedure to put that old file away safely so that it is not
opened in error when the user thinks the new file is open. IMO, the
latter sort of trivial and almost laughable situation (confusing the
files) is the most likely to cause you problems, but there won't be so
much laughing if data are compromised.

Will these new files run well with just the default conversion? All
that I have converted have done so with the exception of those which
used many Windows API calls. Some of these failed, not because the
version of Access changed but because the version of Windows had
changed as well. But my guess is that your thousands of databases will
not contain extensive API calls.

If you were to follow this route you could reserve your time for
hands-on help of those few who did experience a problem. They should
still have the original available for you.

Jan 7 '07 #4
As Gunny pointed out, you must use the A2002 file format if you want to
create MDEs. Otherwise there is little practical difference.

I understand that corporate environments have a deal of inertia when it
comes to moving, but Office XP seems like a strange choice at this point.
Access 2007 has so much new functionality, e.g.:
http://allenbrowne.com/Access2007.html
It's understandable if they consider that too new to use yet, but Office
2003 is a very stable and mature product now. Office XP will exit the
support cycle sooner than 2003, so I don't see the logic there.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"tombsy" <ic************@tiscali.co.ukwrote in message
news:45**********@mk-nntp-2.news.uk.tiscali.com...
Hello Group.

I work for a company who is about to embark on a long awaited Office
upgrade from Office 97 to Office XP.

Office XP comes with Access 2002.
I am an accomplished Access developer so I have read up on the
complexities of upgrade in the corporate environment.
Also the need to carry out a full MDB audit to get rid of the redundancy
etc etc

My specific question is this ....
We have thousands of user built databases that I want to automatically
convert from Access97 but I cant get a clear answer from the interweb as
to which format to convert to (Access 2000 or Access 2002).

We do not have any Access2000 users, so can I leap from A97 to A2002 ?
or should I do a staged upgrade A97 to A2000. Let the dust settle, then
convert A2000 to A2002.

your advise is greatly appreciated.

kind regards

tombsy
Jan 8 '07 #5
Thanks for both your comments.

We are going to roll out Access XP runtime and set the registry switch for
prevent the upgrade message from appearing.
Anyone opening a A97 db using A2002 should be able to use the db but not
change objects(as an interim step).
Then i can run my bespoke conversion database which will automatically work
thro a list of MDB files and perform the conversion to A2002 for all the non
dev built apps. Our controlled dev built apps will get the full dev
treatment as will likely have complications with the upgrade.

"tombsy" <ic************@tiscali.co.ukwrote in message
news:45**********@mk-nntp-2.news.uk.tiscali.com...
Hello Group.

I work for a company who is about to embark on a long awaited Office
upgrade from Office 97 to Office XP.

Office XP comes with Access 2002.
I am an accomplished Access developer so I have read up on the
complexities of upgrade in the corporate environment.
Also the need to carry out a full MDB audit to get rid of the redundancy
etc etc

My specific question is this ....
We have thousands of user built databases that I want to automatically
convert from Access97 but I cant get a clear answer from the interweb as
to which format to convert to (Access 2000 or Access 2002).

We do not have any Access2000 users, so can I leap from A97 to A2002 ?
or should I do a staged upgrade A97 to A2000. Let the dust settle, then
convert A2000 to A2002.
your advise is greatly appreciated.
kind regards
tombsy

Jan 8 '07 #6
You're welcome. Good luck with it.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"tombsy" <ic************@tiscali.co.ukwrote in message
news:45**********@mk-nntp-2.news.uk.tiscali.com...
Thanks for both your comments.

We are going to roll out Access XP runtime and set the registry switch for
prevent the upgrade message from appearing.
Anyone opening a A97 db using A2002 should be able to use the db but not
change objects(as an interim step).
Then i can run my bespoke conversion database which will automatically
work thro a list of MDB files and perform the conversion to A2002 for all
the non dev built apps. Our controlled dev built apps will get the full
dev treatment as will likely have complications with the upgrade.

"tombsy" <ic************@tiscali.co.ukwrote in message
news:45**********@mk-nntp-2.news.uk.tiscali.com...
>Hello Group.

I work for a company who is about to embark on a long awaited Office
upgrade from Office 97 to Office XP.

Office XP comes with Access 2002.
I am an accomplished Access developer so I have read up on the
complexities of upgrade in the corporate environment.
Also the need to carry out a full MDB audit to get rid of the redundancy
etc etc

My specific question is this ....
We have thousands of user built databases that I want to automatically
convert from Access97 but I cant get a clear answer from the interweb as
to which format to convert to (Access 2000 or Access 2002).

We do not have any Access2000 users, so can I leap from A97 to A2002 ?
or should I do a staged upgrade A97 to A2000. Let the dust settle, then
convert A2000 to A2002.
your advise is greatly appreciated.
kind regards
tombsy


Jan 8 '07 #7

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

Similar topics

29
by: Mark B | last post by:
We have an Access app (quite big) at www.orbisoft.com/download. We have had requests by potential users to have it converted to an SQL version for them since there corporate policy excludes them...
4
by: -Michelle- | last post by:
Hi I am using A2003 on XP. The client has A2000. So I have ensured that I have developed based on A2000 and compiled as such. I have found that in a number of cases now, I have used (what I...
22
by: Bradley | last post by:
Has anyone else noticed this problem? I converted the back-end to A2000 and the performance problem was fixed. We supply a 97 and 2000 version of our software so we kept the backend in A97 to make...
12
by: dixie | last post by:
Can someone familiar with Access 2003 please answer this question? I am asking because I don't have the use of A2003. When Access 2003 finds an Access 2000 database, does it come up with some...
3
by: Tim Marshall | last post by:
I have a user who has what I assume is a VB application: it's opened with an exe file, there are numerous dll files in the directory in which the executeable resides, along with an mdb file that I...
0
by: Tom | last post by:
All: I posted on this yesterday, but for whatever reason, Google isn't dealing nicely with it... Anyway, I need to install A2000 on a computer that already has A2002 so I can create A2000 mde...
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...
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...
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)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...

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.