mde FILE

[ahmad hamzeh]

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]

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

 

[Bill Taylor]

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?

 

[ahmad hamzeh]

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