MS Access data conversion

Author

mde FILE

ahmad hamzeh

2005-07-09, 3:24 am

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

Douglas J. Steele

2005-07-09, 7:24 am

"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@hotmail.com> wrote in message
news:e2zMABFhFHA.1460@tk2msftngp13.phx.gbl...
> 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
>
>

Bill Taylor

2005-07-14, 8:25 pm

Is your db referencing a specific mdw file on your system that may not be
on or in the same location as the client machines?

"Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
news:uBCYNdHhFHA.3692@TK2MSFTNGP09.phx.gbl...
> "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@hotmail.com> wrote in message
> news:e2zMABFhFHA.1460@tk2msftngp13.phx.gbl...
when[color=darkred]
..mde[color=darkred]
from[color=darkred]
>
>

ahmad hamzeh

2005-07-20, 3:24 am

My Db has a function that create a tables links with the remote db and use
adox and my front end db work just as interface with the connection with a
backend db

"Bill Taylor" <bill@artsystems.com> wrote in message
news:ujgwmyMiFHA.1460@tk2msftngp13.phx.gbl...
> Is your db referencing a specific mdw file on your system that may not be
> on or in the same location as the client machines?
>
>
> "Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
> news:uBCYNdHhFHA.3692@TK2MSFTNGP09.phx.gbl...
> with
> but
> the
> production
> that
> when
> .mde
> from
>
>
>

Sponsored Links