Error 1904 Access with new pc

[vagman]

I put my old Access mdb on my new pc windows 10 and when installing office 2000 or 2003 I see e
Error 1904.Module C:\Program Files\Common Files\System\OLE DB\MSOLAP.DLL failed to register.

I click ignore and the installation is done but when I open db and click a button the db is closing immediately
The same db works perfect in 5 other pc

 

[isladogs]

Neither of those versions of Access have been officially supported since Windows 7.

Microsoft Access Version Features and Differences Comparison Matrix

Microsoft Access Version Differences with database formats, field types, security, containers, form and report features, discontinued features, etc.

www.fmsinc.com

You may be lucky if you are able to properly register that DLL file
However, the fact that you got either version to work on other workstations is surprising and you may find other problems later.
Recommend you upgrade to a newer version of Access

 

[vagman]

Neither of those versions of Access have been officially supported since Windows 7.

Microsoft Access Version Features and Differences Comparison Matrix

Microsoft Access Version Differences with database formats, field types, security, containers, form and report features, discontinued features, etc.

www.fmsinc.com

You may be lucky if you are able to properly register that DLL file
However, the fact that you got either version to work on other workstations is surprising and you may find other problems later.
Recommend you upgrade to a newer version of Access

the problem was in windows installation and admin user
I refreshed win10 and installed office 2000 and db worked
When installing office 2013 an later the db works with 2013 and not with office 2000
To work with office 2000 again I have to uninstall office 2013

 

[isladogs]

It is possible to run multiple versions of Office on the same workstation.
Indeed I run A365 and A2010 (both 32-bit) on my main development PC which runs Windows 10 64-bit.
Prior to that, I had a dual install of A2010 & A2003 on a Win 7 PC

However there are issues that you need to take into account. See my article:

Installing Multiple Office Versions

This article explains how you can successfully install more than one version of Office on the same workstation including Access runtime and mixed bitness installations

isladogs.co.uk

 

[Pat Hartman]

To work with office 2000 again I have to uninstall office 2013

When you have multiple versions of Access installed, they fight over control of the registry. So, the last Access version to open is the one that responds on a double click for extensions that both support. To run the application using a specific version, do NOT double-click on the file name. Open the specific version of Access and use that to open the database.

For a more permanent solution, create a shortcut to each application you use. In the shortcut, execute the version of Access you want with the specific .mdb or .accdb as the parameter.

A second more permanent solution is to change the extension associations. Associate .mdb, .ldb, .mde with the old Access version and everything else with the new Access version. That will solve the problem.

 

[vagman]

it is possible to have only access 2000 from office 2000 and office 2019 without access 2019 (only word excel outlook)?

 

[Pat Hartman]

Depends on what you want to do. You can install parts of the Office suite without installing all of it. Not sure why you would ever want to stick with A2k though? If you are trying to use A2K to automate other Office components, you could have problems.

 

[isladogs]

You can certainly install parts of old Office suites such as Access 2000.
However, click to run installations of new versions such as 365 can only be installed in their entirety. I expect that applies to Office 2016/19/21 as well.

Like Pat, I see no benefit in you installing A2000 along with Office 2019.
But if you really want to use A2000, install that and the entire Office 2019 suite but take care with using A2019 or just ignore it completely.

 

[Pat Hartman]

If you end up with multiple versions of Access installed, just remember, the last version installed or opened gets custody of the .mde and .mdb extensions. That means if you install Access 2019 last, that is what will open on a double-click. Therefore, you would have to open A2K and then open your database in order to use the old version.

 

[vagman]

the problem is that when I have installations of access 2000 or 2003 and office2016-2019 access 2000 or 2003 give me errors of vb... If I uninstall office 2016- 2019 access 2000 works great
I prefere access 2000-2003 because have fast and simple menus
The menus of later versions of access are nightmare

 

[isladogs]

Newer versions of Access are less tolerant of coding errors which is generally a good thing but may mean errors that need fixing.
Anyway, its your choice on how to proceed.

 

[vagman]

if I can find a way to have this menu it will be great and I will stop using access 2000-2003

 

[isladogs]

Have a look at my database objects utility

View Database Objects & Metadata

This article includes an example app used to view all objects in a database together with their properties and metadata.

isladogs.co.uk

You may also find my navigation pane helper app helpful.

Navigation Pane Helper Add-In

This add-in is designed to make it easier and more efficient to use the many navigation pane options with as few clicks as possible.

isladogs.co.uk

It is also available as a stand alone app for importing into your own database

 

[Josef P.]

If I can find this starter crank I will buy a new car. (SCNR)
https://www.fotocommunity.de/photo/oldtimer-von-ford-motorhaube-mit-kurbel-ingeborg-k/31219183

The database window for Access 2010/2013:

Avenius Individual Datenbank Programmierung – DBC2007

Individual Datenbank Entwicklung Avenius, Access Ribbon Website

www.avenius.de

I don't know if this will still work with Access 2016+.

 

[vagman]

Have a look at my database objects utility

View Database Objects & Metadata

This article includes an example app used to view all objects in a database together with their properties and metadata.

isladogs.co.uk

You may also find my navigation pane helper app helpful.

Navigation Pane Helper Add-In

This add-in is designed to make it easier and more efficient to use the many navigation pane options with as few clicks as possible.

isladogs.co.uk

It is also available as a stand alone app for importing into your own database

thank you very much
I will check it

 

[isladogs]

My suggestion is that you just accept the nav pane is different from the old database window and learn how to use it efficiently. However, there are some like you who dislike it and it is for those people that my utilities in the links are designed

 

[vagman]

After installing various versions of access 2000 2003 2007 2016 2019..
Access 2000 or 2003 crach when I click to open a form
I had in the past same problem but when I uninstall access version later than 2003 it worked
Now no
I think is conflict with vba and and don't want to reinstall windows to solve

 

[isladogs]

You may have leftover files or registry entries from your multiple installations.
Try using MS SARA (Support and Recovery Assistant) to remove all traces of Office and start again.

 

[Gasman]

You may have leftover files or registry entries from your multiple installations.
Try using MS SARA (Support and Recovery Assistant) to remove all traces of Office and start again.

Colin,
Do you need to install that, or can you just run it?

 

[isladogs]

It must be installed

About the Microsoft Support and Recovery Assistant - Microsoft Support