Edit Design and not losing data from an mde file

[romio]

Still not sure how to do this, after I convert my database and create an mde file few changes might accrue in the future, I have tried to make some changes for testing purpose and then create a new mde file and saved it with replacing the older one but I had lost my new data which was entered in the old mde file?

Q: how can I make the new change on my original file and not lose my new data in my mde file.

 

[Rich]

Split the DB into front and backend, just make the front an MDE

 

[romio]

Split the DB into front and backend, just make the front an MDE

So If I understand correctly those were my steps:

1. I have created a folder a new folder in my server and copied db2 in there.
2. Open db2 and split it within the same directory.
3. Go to my network computer and map the file db2 (not db2_be)

Am I doing the right steps?

 

[jrjr]

The Front end (FE) will contain all of your forms for the end users to manipulate data with. The Back end (BE) will contain the tables that actually store the data. FE takes the form of an .mde and the BE remains a .mdb. Now you can create new FE .mde for updates and not disturb your data stored in the BE. See?

You can have the FE on the server, I do this, and then simply mail a shortcut to the users. Depending on your network, many prefer to install the FE directly on the users machine as this can improve performance. With this approach you would have to re-link the tables to the BE when you install the FE on the users machine and again if there is a physical address change of the BE