VBA code executing problem

Z

Zdenek Varmuza

Hello all

I have problem with VBA code in Access database.
When I try to execute any included code error message appear:

"A problem occurred while Microsoft Office Access was communicating with
the OLE server or AcriveX control"

This database was created in Office 2000 Access French version, OS
Windows 2000 French version. This problem does not exist when I open
database and run code on French system (Win XP FR, W2K FR).

This problem arise when I open this database on English or Czech system
(Win XP EN, Win XP CZ, W2K CZ) does not matter which version of Office
(2000, 2003, FR, CZ, EN)

Error message suggests some steps to check so I did them.
(check security settings and install MS JET 4.0, wrong expression, link
missing, ...)

When I copy&past code to blank database it works.

All references (VBA editor - tools - references) are OK

Any advices what else should I check and try?
(I do not have a lot experiences with Access)

Regards

Zdenek Varmuza
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top