Re: mde FILE

Tech-Archive recommends: Fix windows errors by optimizing your registry



"Doesn't work" doesn't give us much to go by. Unless there's a problem with
the References collection, I can't see why it would work on one machine but
not on another, but if that were the case, you'd have the problem with the
References collection with the MDB as well.

While you can use the following undocumented code to automate the production
of an MDE

Dim a As Access.Application
Set a = New Access.Application
a.SysCmd 603, "db2.mdb", "db2.mde"
Set a = Nothing

I'd suggest strongly that you find out what's causing the problem, so that
you can distribute the MDE as you should be.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"ahmad hamzeh" <ahmad_hotmail.com@xxxxxxxxxxx> wrote in message
news:e2zMABFhFHA.1460@xxxxxxxxxxxxxxxxxxxxxxx
> Dear All
> I create an .mde file for my project and I use an Autoexec macro as
> startup
> way which run a function, the .mde file work fine on my system , but when
> I
> try to download or copy the file in another system it doesnt work, but
> when
> I copy the .mdb file and convert it to .mde file in that system the .mde
> file work.
> so I need to create the .mde on the target system which prevent me from
> distribute my application
> are there any one who could help me in this issue
> Thanks
> Ahmad
>
>


.



Relevant Pages

  • Re: MDE Problem
    ... within the mde. ... The implication of what you say seems to be that the MDE file has been ... entered (in an event property), Access is raising the event and is trying ... run either a macro, user-defined function, or event procedure - but it ...
    (microsoft.public.access.setupconfig)
  • Re: File size the same after major deletions
    ... I see where you deleted stuff and the MDE was still the same size. ... What I didn't see was any reference to a compact and repair on the MDB ... I had a database over 300Mb that I tried to ... >> It's set up with an .mde file that is used as the User ...
    (microsoft.public.access.gettingstarted)
  • RE: creating external reusable functions
    ... > recreate the front end MDE for each user, and just distribute the library to ... must the front end MDE be recreated? ... See http://www.QBuilt.com for all your database needs. ... >> which holds the other database objects, can be an MDE file. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Creating MDEs
    ... including the inability to create an MDE. ... There may be coding errors in your database. ... >an MDE file from the ... database format is ...
    (microsoft.public.access.forms)
  • Re: speeding up the performance of a split database
    ... However, the mde is smaller, the mde ... utilities->create mde file. ... > saying that I SHOULD compile my VBA code to speed things up? ... The suggestion to de-compile is kind of a hammer..and it can often fix some ...
    (microsoft.public.access.formscoding)