2 access97 - 2000 conversion questions.

[ajames54]

1) What is the Max stable size for an Access 2000 Database? My
750 MB A97 Database Converts to an 829 MB A2K database ...at what
size will it become unreliable?

2) I say above that it converts but I'm not too sure... every
time I attempt to convert it I get an "Out of System Resources"
or "Out of Disk Space" message, which is odd as i have run it on
machines with 256 and 512 MB RAM and at least 8 GB of free hard
drive space. every time the file is the same size and appears to
be complete.. I've been using the files for testing and they seem
to work fine... but with the error message there I DO NOT want to
move into production.

 

[Tony Toews]

1) What is the Max stable size for an Access 2000 Database?

2 Gb.

My
750 MB A97 Database Converts to an 829 MB A2K database ...

That seems reasonable enough. A clients 200 Mb BE went to about 240
Mb or so.

at what
size will it become unreliable?

2 Gb.

2) I say above that it converts but I'm not too sure... every
time I attempt to convert it I get an "Out of System Resources"
or "Out of Disk Space" message, which is odd as i have run it on
machines with 256 and 512 MB RAM and at least 8 GB of free hard
drive space. every time the file is the same size and appears to
be complete.. I've been using the files for testing and they seem
to work fine... but with the error message there I DO NOT want to
move into production.

Your concern is most understandable. Have you tried importing into a
new MDB?

Also use the sysrels utility from www.trigeminal.com to copy the
layout of the relationships window. Hmm, if you can from different
versions of BE. You can't so you might have to create an empty MDB in
A97, import just the table definitions and relationships, copy the
relationships window layout, convert this "template" mdb to A2000 and
then copy the relationships window layout from it.

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

 

[ajames54]

2 Gb.


That seems reasonable enough. A clients 200 Mb BE went to about 240
Mb or so.


2 Gb.


Your concern is most understandable. Have you tried importing into a
new MDB?

Also use the sysrels utility from www.trigeminal.com to copy the
layout of the relationships window. Hmm, if you can from different
versions of BE. You can't so you might have to create an empty MDB in
A97, import just the table definitions and relationships, copy the
relationships window layout, convert this "template" mdb to A2000 and
then copy the relationships window layout from it.

Tony

Thanks Tony... creating a new 97 database and importing
everything from the old one allowed the new one to convert with
out any errors.. (and in about 1/3 the time).

 

[Tony Toews]

Thanks Tony... creating a new 97 database and importing
everything from the old one allowed the new one to convert with
out any errors.. (and in about 1/3 the time).

Ah, sounds like the original had some minor corruption then.

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