Access Runtime Installation has Unwelcome Effects

Posted on 2005-05-11
Last Modified: 2008-03-17

We are in discussions with a third party supplier due to problems caused by installation of their product. This product involves a local installation of Access 2000 Runtime despite the machines already having XP or 2003 installations. This causes all sorts of problems. We can get round some (e.g. the penchant for Access to open any database using the last used version of Access by using shortcut switches) however too many other things are screwed up for the situation to be considered acceptable. For example, the below code:


Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

    Dim oAcc As Access.Application
    Set oAcc = New Access.Application
    oAcc.Visible = True
    oAcc.OpenCurrentDatabase "C:\Test.mdb"
    Set oAcc = Nothing

    Exit Sub

    MsgBox Err.Description
    Resume Exit_Command0_Click
End Sub


results in the below message:
Please Wait while Windows configures Microsoft Access 200 SR-1 Runtime

Gathering required information
as well as a progress meter.

Allowing it to run it's course results in:
Error 1321. The installer has insufficient privileges to modify this file: C:\Program Files\Microsoft Office\ART\System\FM20.DLL

And cancelling leads to:
ActiveX component can’t create object

The response from the vendor is predictable - "no one else has a problem". I'd like to go to them with a concrete "x is causing y and resulting in z" so we have some leverage to insist that they include a check for existing access components\ include the option NOT to install the runtime with future installations. Overall they are pretty responsive but I would like to be be a little less vague than "stuff stops working". Does any one have any ideas or experience of this? I know from the web that I am not unique in experiencing problems attributable to the runtime installation but I can't find specific mention of, for example, this problem.

Cheers Guys & thanks in advance
Question by:pootle_flump
    LVL 22

    Assisted Solution

    by:Kelvin Sparks
    If the runtime was installed with the windows MSI (used by the Access packaging wizard) there is likely to be problems with other Versions of Access. It tends to make the 2000 runtime the default program for all mdbs. This then needs a specific startup string for all other mdns to invoke the appropriate version of Access

    I supply all runtimes with the following product which claims not to cause this - and I've tested it on a couple of units and it seems to work

    LVL 11

    Author Comment

    Cheers Kelvin - it looks like it has been produced for precisely the problems I am experiencing.

    Anyone got any further ideas that can help me convince the supplier we need some changes making?
    LVL 36

    Accepted Solution

    the most important thing is to make sure that the RT is installed to a completely different folder than the default. If it goes to the default, you will have the kinds of things you are seeing as it will overwrite some of the dll's that are different and needed in the full version.

    If the Install is pointed to some thing different like \Program Files\AccessRT you can have multiple version with no problems. (i've got A02, A02RT and A97 all on one)

    "open any database using the last used version of Access by using shortcut switch"

    To get around this you need to modify the short cuts to include the full path to each version and app (or open the app and then select the file from the dialog)

    LVL 11

    Author Comment

    Thanks Sid - any idea where the Access 2000 Runtime default installation folder is?

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now