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 Removed)
***********************************************

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.....

--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg


"Sham Yemul" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 Removed)
> ***********************************************
>
>