Access 2003 Please Help

[chet snow]

We have Access for Windows 95 installed on our new Windows
XP computer. Now we want to upgrade to Access 2003 in
Office 2003 Pro version. But before we do this we need to
know if we can use our Databases created in Access 95/97 in
the Access 2003 version. We've tried phoning Microsoft but
just got a run-around. Can anyone tell us if this is
possible and how to do it? What we want to do is transfer
the individual files to the new Access.

Chet Snow

 

[John Vinson]

But before we do this we need to
know if we can use our Databases created in Access 95/97 in
the Access 2003 version.

Yes, you can. Simply open the database in A2003 and accept Access'
offer to convert the database. IME there are occasional minor problems
(2003 is stricter about some query syntax than A9x for example) but
usually the conversion is straightforward; the data itself will come
over without difficulty.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Brendan Reynolds]

If these MDBs were originally created in Access 95 or Access 97, you're
unlikely to encounter any great difficulty. Difficulties can arise with MDBs
that were originally created in Access 2 and later converted to Access 95 or
Access 97, and are using the Microsoft DAO 2.x/3.x Compatibility Library,
because there is no 2.x/3.6 compatibility library (3.6 being the version of
DAO used with Jet 4, in Access 2000 and later). If you find a reference to
that library in any of your MDBs, I advise, before converting, removing that
reference and replacing it with a reference to the appropriate version of
DAO (3.0 for Access 95 if I remember correctly, 3.51 for Access 97). Then
try to compile, and fix any compilation errors that you find before
converting to Access 2003.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.