MDE, FrontEnd/BackEnd

[TheB]

Hi there,

I am currently in process of building Access database for a friends business. I was hoping to create an MDE file for him to use as I wanted it to be executed via a icon on his desktop rahter than going into Access. I thought I could achieve this with an MDE executable file. However as I dig deeper into this project I see that once an MDE file is created it is very difficult to modify the application. I am not sure he would like this as there bound to be changes in the future. I am very new to access and I was wondering if you recommend the front end/back end setup. If so could you explain how to set this up and establish links between the two? Or if you could lead me to some good documentation to read on how to do it I would appreciate it.

Thanks in advance.

...TheB

P.S. btw, great forum. I'm glad I found it.

 

[chewy]

just make a backup copy of the database before you make the mde file.

 

[TheB]

Pat and chewy,

Thanks for your help. WRT to your reply Pat. If I had to make a modification to the database what would happen to all the existing data with the new version?

Or would I just copy the new MDE file to users PC?

I am assuming the MDB file contains all the data and the MDE contains the forms/reports etc?

Thanks again.


...TheB

 

[TheB]

Pat,

I am assuming I am not going with the split example when I asked my last question. From your note it seems that i can modify the Access database and regenerate the MDE. what would I have to re-install on the users PC to complete the update? The MDB & MDE. Or could I just copy over the MDE and it would work fine?

Thanks again.