Deploying DB to users! (mde, self installation, update user version)

[MsLady]

I have a db with more than 100 forms, reports - objects. My backend tables are linked sybase tables. What is the best way to hand this over to the users?

1. I want to create a mde version (which is not working, here's my problem Failure In Creating MDE File
2. I want a way to send this application to the user, in order that is installs on their desktop or a location i specify on the user's drive. I have no clue how to accomplish this, but i know that when i download some applications they do end up on my desktop , so they must have done it somehow. Please help?
3. I want to have a master mdb hidden on the network somewhere, and when i make changes to that (e.g. my form or reports). And the next time the user goes into the version installed on their drive, it checks for the last version of the front end, and if that's not it, it erases the old one they have and installs my new version for them automatically. I know this can be done. Can you help me?

I'd really appreciate if anyone can help me please in any way. Advice, links, tutorial, whatever. Many blessings will come to you!


Ghudson! Before you attack me, i've done a search on the forum and though i've seen some posts, i can't seem to find one best for my means Thanks!

 

[Smart]

We used to de[loy a database to the users Pc many moons ago and used the attached code to do this.Can't remember the exact process but the attached file may be of some help
NB Shift into the database and design the form

 

[alastair69]

Smart,

You have forgoten to attach the code/database.

Alastair

 

[Smart]

RE:REeploying DB to users! (mde, self installation, update user version)

Oops another blond moment

We used to de[loy a database to the users Pc many moons ago and used the attached code to do this.Can't remember the exact process but the attached file may be of some help
NB Shift into the database and design the form