MDE version of ACC97 database not working on other machines 
Author Message
 MDE version of ACC97 database not working on other machines



Quote:
>Can anyone explain to me why an ACC97 .mdb when compiled on my computer
>into a .mde won't work correctly on another users machine, but the
>original .mdb will function correctly on both?

>The exact problem appears when the user hits a button on a particular
>form which in turn runs an [Event Procedure].  However, the procedure
>bombs out and gives the error message attached.

>I've had some recent problems with the wrong version of comdlg32.ocx
>being loaded on my machine and not the others, but all machines now run
>the same version so I've ruled this out.  The problem only manifests
>itself when I compile the .mdb so could something else have changed on
>my machine which is causing the problem?

Some reference(s) are different on the two machines. In an mdb, they can be
sometimes fixed up automatically when the project is loaded. It is not
possible in an mde because the code is compiled and nothing can be changed.

Please do not post any attachments in a newsgroup without "binaries" in its
name.

--
(remove a 9 to reply by email)



Sun, 16 Mar 2003 03:00:00 GMT  
 MDE version of ACC97 database not working on other machines
Mystery,
Does the mde work on your machine?
I would be looking at;
backup, decompile, compact and repair, recompile, compact and repair, create mde, retry.
I assume all your references are OK.
--
Hope This Helps,
Jeff Davies
Quote:

> Can anyone explain to me why an ACC97 .mdb when compiled on my computer into
> a .mde won't work correctly on another users machine, but the original .mdb
> will function correctly on both?

> The exact problem appears when the user hits a button on a particular form
> which in turn runs an [Event Procedure].  However, the procedure bombs out
> and gives the error message attached.

> I've had some recent problems with the wrong version of comdlg32.ocx being
> loaded on my machine and not the others, but all machines now run the same
> version so I've ruled this out.  The problem only manifests itself when I
> compile the .mdb so could something else have changed on my machine which is
> causing the problem?



Mon, 17 Mar 2003 06:36:43 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Procedure working on some machines and not others

2. FileSystemObject: works on some machines, others not

3. FileSystemObject: works on some machines, others not

4. DBGrid Delete Key function not working on some DBGrids while it works on others

5. Error 3071...Why on one machine and not on others

6. Excel file opened in IE3 - on one machine starts Excel, others does not

7. MDE's will not run on different machines - sudden Access crash

8. Acc97: LastModified and Bookmark not working on ODBC table

9. Reference to MDE does not work in Access2000

10. Works on my PC, but not others????

11. Everything works in DEVELOPMENT PC and not others

12. Data Control Refresh works sometimes, others Not?!

 

 
Powered by phpBB® Forum Software