By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,959 Members | 1,160 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,959 IT Pros & Developers. It's quick & easy.

migrating from access 97 to access 2000

P: n/a
ARC
Hello,

What is the best way to do this. I have many off-site locations with access
97 back-end databases. If I wish to go to access 2000, and don't want to
manuall upgrade the back ends to access 2000, how do I automate this? If
there isn't a way to do this through code, do I need to install to a
different folder with a blank 2000 database, and manually import each
table's data from the 97 database? Or is there an easier way?

Many Thanks,
May 20 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"ARC" <an**@andyc.comwrote:
>What is the best way to do this. I have many off-site locations with access
97 back-end databases. If I wish to go to access 2000, and don't want to
manuall upgrade the back ends to access 2000, how do I automate this? If
there isn't a way to do this through code, do I need to install to a
different folder with a blank 2000 database, and manually import each
table's data from the 97 database? Or is there an easier way?
You can programmatically compact a database to a new version. However, according to
the A2000 help using the DAO compactdatabase method ". You can compact newdb only to
a version that is the same or later than that of olddb." But the ADO compactdatabase
method will work to the A2000 version.

That said it's no big deal if your users are on A2000 and the BE is in A97.
Performance might not be quite as good although I don't have any concrete reasons for
saying that.

I would strongly urge you to rename to old database and move it to a child folder
before doing the compact. But keep it around just in case. Now you don't want to
leave it in the same folder in case someone starts mucking about.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
May 20 '07 #2

P: n/a
On Sun, 20 May 2007 12:30:37 -0500, "ARC" <an**@andyc.comwrote:

There is a way. See the Application.ConvertAccessProject Method
(this is from A2007, but I think a similar method is available in
A2000). Not sure why you're striving to stay 3 versions behind the
current one though.

-Tom.

>Hello,

What is the best way to do this. I have many off-site locations with access
97 back-end databases. If I wish to go to access 2000, and don't want to
manuall upgrade the back ends to access 2000, how do I automate this? If
there isn't a way to do this through code, do I need to install to a
different folder with a blank 2000 database, and manually import each
table's data from the 97 database? Or is there an easier way?

Many Thanks,
May 20 '07 #3

P: n/a
ARC
Thanks!

I'm staying behind mainly because I have Access 2000 developer already, and
I've heard 2003 has issues with rights/priveldges being too server, and 2007
is a bit too new to be proven, but I could be wrong.

Thanks again,

"Tom van Stiphout" <no*************@cox.netwrote in message
news:g8********************************@4ax.com...
On Sun, 20 May 2007 12:30:37 -0500, "ARC" <an**@andyc.comwrote:

There is a way. See the Application.ConvertAccessProject Method
(this is from A2007, but I think a similar method is available in
A2000). Not sure why you're striving to stay 3 versions behind the
current one though.

-Tom.

>>Hello,

What is the best way to do this. I have many off-site locations with
access
97 back-end databases. If I wish to go to access 2000, and don't want to
manuall upgrade the back ends to access 2000, how do I automate this? If
there isn't a way to do this through code, do I need to install to a
different folder with a blank 2000 database, and manually import each
table's data from the 97 database? Or is there an easier way?

Many Thanks,

May 20 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.