msacc.olb / Access 2000 v9 (in)compatability

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Flynn (anonymous_at_discussions.microsoft.com)
Date: 09/04/04 

Date: Sat, 4 Sep 2004 03:32:13 -0700

I'm maintaining a system with a VB6 (SP6) front end and an
Access 2000 v9 database running under XP, using ado for
standard database calls. This has worked fine for a few
years now.

I've developed two new reports in the Access 2000 database
(running in development under Access 2002 v10) and am
using the following syntax to call the reports from the VB
front end:

  Db.Close ' closes the ado connection

  appAccess.OpenCurrentDatabase "C:\mydatabase.mdb", False
  appAccess.DoCmd.OpenReport "MyReport", acViewNormal
  appAccess.CloseCurrentDatabase
  appAccess.DoCmd.Quit acQuitSaveNone

To achieve this, I included msacc.olb as a project
reference in VB.

This works fine in my development environment, but in the
end-user environment (Access 2000 v9), rpcrt4.dll always
falls over at the "appAccess.OpenCurrentDatabase" command.

I'm guessing this is because the Access 2000 end-user
database recognises msacc9.olb rather than msacc.olb. So
a few questions:

1). Does my diagnosis sound correct?

2). I've copied msacc9.olb to my development machine but
VB won't recognise it as a project reference. Is there a
way I can get msacc9.olb registered on my development
machine without a doing a complete installation of Access
2000?

3). If I do a complete installation of Access 2000 v9 on
my development machine, will this a) let me register
msacc9.olb as a project reference and b) cause any
problems with Access 2002 v10?

Getting the end-users to upgrade to Access 2002 isn't
currently an option. Any help gratefully received!

Relevant Pages

  • Re: How do I import DOS files into Excel?
    ... I suppose the first question is, do you have the old database running on ... data from the old program into a common format, ... most database software could export to CSV files. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.externaldata)
  • Re: Is 5.0.7 ready for production?
    ... so its name can be changed without a matching change ... > the system has locked up about 6 times with the database running, ... > the database is started. ... Doesn't the Compaq watchdog stuff ...
    (comp.unix.sco.misc)
  • Re: error executing query
    ... > I have a database running on MSDE it was working fine. ... different software installed on the computer running MSDE? ... databases like MSDE and SQL Server can expose network issues such as ...
    (microsoft.public.sqlserver.connect)
  • Re: First attempt at db (All replies gratefully received)
    ... Don't know the database specs. ... > week just to get a simple database running, if they're a beginner to ... or a full production tool like DreamWeaver. ... >> week just to get a simple database running, ...
    (microsoft.public.inetserver.asp.db)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)