Re: Using Access 97 and Access 2003 on same computer

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: GVaught (glvaughtRemoveThis_at_hotmail.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 17:49:48 -0600

When you installed Office 2003 did you install to a completely separate
directory than the default or the location of the Office97/Access97
database? If not, this is your problem. Uninstall Office 2003, Uninstall 97.
Reinstall 97 to one directory then install Office 2003 to a completely
different directory. Installing Office 2003 to a completely different drive
is even better or vice versa with Access 97.

VS.Net 2003 will not interfere to my knowledge with either application
version. I have VS.Net/Access 97/Access 2002 running on my desktop machine
with no conflicts.

Be aware that if you double click on your Access 97 database it will not
open Access 97 it will open Access 2003. If you double click on Access 2003
and no other database is open it should invoke Access 2003. If you have
Access 97 open and double click on a 2003 database or 97 database, it will
open the database under a new instance of Access 97. If you need to open two
different versions at any time you have to open both through Start |
Programs | Access 97 | Pick the database and Start |Programs | Access 2003
|Pick the database. It does not matter which version you open first. 

-- 
G Vaught
"TechniMom" <anonymous@discussions.microsoft.com> wrote in message
news:2a2201c47e32$a5ae61b0$a301280a@phx.gbl...
> Access 2003 gives me a "Microsoft Visual Basic"
> dialog "Object library not registered".  Clicking help
> gets me Access 2003's help file which says to reregister
> the application.
>
> I have a standalone version of Access 97 that I've been
> using for years.  Last year I installed Office 2003
> Professional, but kept Access 97 and have been using
> Access 97 ever since.
>
> My husband also has Visual Studio .NET 2003 installed on
> our computer.
>
> Now I want to use Access 2003 for a new database (and
> VBA), but keep Access 97 for my old ones.  (I don't have
> the time to deal with converting all my VBA code to 2003).
>
> If I reregister Access 2003, will it mess with the
> functionality of Visual Studio or of Access 97?

Relevant Pages

  • Re: Access 2002 file wont work in 97
    ... No version of Access is capable of reading files from newer versions. ... Access 97 format through Tools | Database Utilities | Convert Database. ... since the default format for both Access 2002 and Access ... > then installed Office XP. ...
    (microsoft.public.access.setupconfig)
  • message: The wizard is unable to create your data access page
    ... I've installed Office 2003 and applied all the latest patches. ... access page by using wizard. ... database (the connector icon indicates that the database is not connected - ...
    (microsoft.public.access.setupconfig)
  • RunCommand acCmdLinkTables Fails in Access 2007 (Error 2046)
    ... I have recently installed Office 2007 retaining the previous ... I have converted an Access 2003 database to Access 2007. ... the dialog box to rebuild links to tables held in a back-end Access ... The code runs without problem in the original Access 2003 .mdb format ...
    (comp.databases.ms-access)
  • Re: Using Access97
    ... > I have written a database in Access97 and wish to keep it. ... > installed Office 2000, eliminating Access. ... As long as you don't ever open Access ...
    (microsoft.public.access.setupconfig)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)