Upgrade from Access 95

  • Thread starter Thread starter Joe Jackson
  • Start date Start date
J

Joe Jackson

Ok, now I've got them convinced that we need to upgrade. Here is the next
question they have asked me to research (I'm a SQL DBA, haven't used Access
since 97).

They only use Access as a repository of data, they get the data through a VB
program. What if any problems will they have if the databases are upgraded
to 2000 or 2003? I would imagine that things would go fairly seamlessly but
again, I haven't had much experience with Access in quite a while.

They've kept their drivers up to date, but they are worried that they would
need new drivers and new connection strings (that would mean...can you
believe it....they would actually have to go into the code and make a
change....can't have that can we).

Again, thanks for you input.
 
They only use Access as a repository of data, .......

Hi Joe,

Access itself does not store any data. It is simply a front-end GUI to the JET database. It can
also be used as a front-end for a variety of other databases, including MSDE, SQL Server, Oracle,
etc. You are likely working with version 3.x of the JET database engine right now. Installing
Access 2000/2002/2003 will install a copy of the JET 4.0 database engine, but so will simply
installing Office 2000/2002/2003 without Access (since several other products make use of the JET
database engine). In any case, one should make sure to install the latest service pack for the
JET database engine:

How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine
http://support.microsoft.com/?id=239114


Some issues that you can run into, if you upgrade to JET 4.0, include the following (I'm sure
there are other issues as well):

PRB: Error "Unrecognized Database Format" When You Upgrade to Access 2000 or 2002
http://support.microsoft.com/?id=238401

How To Have Your ODBC Jet 3.5 and 4.0 Applications Co-exist
http://support.microsoft.com/?id=244040



Tom
______________________________________


Ok, now I've got them convinced that we need to upgrade. Here is the next
question they have asked me to research (I'm a SQL DBA, haven't used Access
since 97).

They only use Access as a repository of data, they get the data through a VB
program. What if any problems will they have if the databases are upgraded
to 2000 or 2003? I would imagine that things would go fairly seamlessly but
again, I haven't had much experience with Access in quite a while.

They've kept their drivers up to date, but they are worried that they would
need new drivers and new connection strings (that would mean...can you
believe it....they would actually have to go into the code and make a
change....can't have that can we).

Again, thanks for you input.
 
Back
Top