1 Oct 2003, Access2000, Compile error while using .mde file of Access2000.

[Sham Yemul]

Hello ,

I am getting a message "Compile Error" when using .mde. There is no specific
action/event that it comes ? When I close the application and start it again
it works fine.

If copy .mde file created on my machine to customer's machine, it gives
error "File Not Found", so I copy .mdb file to customers machine, Set the
MSJRO.dll , MSADOX.dll, VBext.dll references compile it and make .mde file
at his place only.

When tested for trial its works fine, but after some usage or at any
unspecifice event/action a message comes in "Compile Error" and user cann't
save anything ?

The application uses two files one as Front End and other as BackEnd, 3 more
files used to increament different IDs independtly, since its Multi-User
application.

I am using ADO thr' code in All the forms, Linked tables to Application
file.

Thank you in Advance for the help.
Regards.

***********************************************
Intellisoft Computer Consultants Pvt. Ltd.
340 A Sakhar peth, Solapur - 413005
Phone : 91-(0)217-262 4713
http:\\intellisoft.netfirms.com
Email : (e-mail address removed)
***********************************************

 

[SA]

Sham:

This can occur if you have different versions of the MDAC (data access
components) installed on your machine and on your clients machine. Access
2000, assumed MDAC 2.1, Win2K installed MDAC 2.5, SQL 2000 was MDAC 2.6,
Xp was MDAC 2.7 (and of course there is now MDAC 2.8 available).

To work around this, set your references to the least common denominator for
MDAC which might appear on any machine. In most instances this revolves
around the ADO objects themselves, i.e. set them to version 2.1 if possible,
or make sure that your client has updated their install of MDAC to the same
version you are running.....