Access 2000 to 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Deb - 31 Mar 2005 21:55 GMT

Will be converting to Access 2003 from Access 2000 soon. Have several large
databases. Any known issues I should be aware of??

Thanks!

Signature

All help greatly appreciated.

Reply to this Message

Van T. Dinh - 01 Apr 2005 02:06 GMT

You don't even need to convert the databases!

Access 2003 can use databases in Access 2000 file format natively.

Signature

HTH
Van T. Dinh
MVP (Access)

> Will be converting to Access 2003 from Access 2000 soon. Have several large
> databases. Any known issues I should be aware of??
>
> Thanks!

Reply to this Message

Chris Mills - 01 Apr 2005 02:39 GMT

Provided you're happy with a decompiled state, surely? After all, the
references MUST change.

Chris

> You don't even need to convert the databases!
>
[quoted text clipped - 5 lines]
> >
> > Thanks!

Reply to this Message

Van T. Dinh - 02 Apr 2005 06:07 GMT

I I couldn't remember exactly but I have just tried using A2K2 to open 2
databases in A2000 file format that have never been opened by A2K2. One of
these was originally written in Access 2.0.

Access 2002 seems to know the old References and changes References to the
new version (from Office 9.0 to Office 10.0 Library) correctly. I am not
sure about ADO both databases used JET Back-Ends and I prefer to use DAO
with JET Back-Ends. DAO 3.6 is the same for both A2K & A2K2.

I guess if you have added other References besides the standard References,
these need to be changed if required.

Both databases seem to work fine in A2000-file-format (before and after
re-compiling), i.e. no conversion to A2K2 file format is required.

Signature

HTH
Van T. Dinh
MVP (Access)

> Provided you're happy with a decompiled state, surely? After all, the
> references MUST change.
>
> Chris

Reply to this Message

Chris Mills - 02 Apr 2005 06:54 GMT

I had no intention of putting you to so much trouble, Van!

I just thought it was worthwhile pointing out that an mdb (ANY mdb) might
benefit from compiling when running on a new version of Access!

Regards
Chris

> I I couldn't remember exactly but I have just tried using A2K2 to open 2
> databases in A2000 file format that have never been opened by A2K2. One of
[quoted text clipped - 15 lines]
> >
> > Chris

Reply to this Message

Chris Mills - 02 Apr 2005 07:00 GMT

My point was, Access certainly fixes up standard references automatically, but
only if there was no corruption or other errors in a conversion. (in my
experience)

Reply to this Message

Van T. Dinh - 02 Apr 2005 07:28 GMT

No problems. I need my memory refreshed occasionally (old age has caught up
finally).

Completely agree with you regarding re-compiling. Whever, I publish a new
version of my databases, I always relink Tables, check References,
Re-Compile, Compact & Repair and finally Make MDE for publication.

Signature

HTH
Van T. Dinh
MVP (Access)

> I had no intention of putting you to so much trouble, Van!
>
[quoted text clipped - 3 lines]
> Regards
> Chris

Reply to this Message

david epsom dot com dot au - 01 Apr 2005 08:58 GMT

Form and Report module public variables are no longer
available as Form/Report properties for use in a control
source or record source.

I'm still not 100% convinced about the practical compatibility
of A2K MDE's on A2003 (obviously, doesn't work the other way
at all).

And I still seem to have occasional problems converting
from A2003 back to A2K.

(david)

> Will be converting to Access 2003 from Access 2000 soon. Have several
> large
> databases. Any known issues I should be aware of??
>
> Thanks!

Reply to this Message

Chris Mills - 02 Apr 2005 01:47 GMT

> I'm still not 100% convinced about the practical compatibility
> of A2K MDE's on A2003 (obviously, doesn't work the other way
> at all).

I was only thinking of mdb's when I said references MUST change.

Deb,
It's claimed there need be no changes at all, after all A2000 format IS native
to later versions.

But I would, as a matter of course, Decompile/Compile/Repair/Compact an app
before shifting it to another version (and afterwards). There could be subtle
corruptions in it ... and though "conversions" tend to be automatic, not so if
there are any "unspecified corruptions".

If you use any more than the 3 (I think) required references, you may need to
check them.

I assume you have purchased (or are happy with) the "Digital Certificate"
arrangements and pesky warnings.

(I don't have direct knowledge of A2003, just A2002 and "downwards" from
there)

Chris

Reply to this Message

sunqiuxia - 24 May 2005 02:18 GMT

dsakjflkjalskdfj;lasd

Reply to this Message