Question Understanding MDE and MDB

[yus786]

Hi

I understand that once a DB is converted to a MDE, it cant be converted back to MDB. So this is my question.

I've completed a DB and converted to MDE. 6 months later i am required to make a change to either the form, or add another module, query, anything.

I still have the original MDB but this wont have the latest data as it's 6 months old.

So how do i link the 2?

Do i work in the MDB file? But then how do i get the data from the MDE version?

Hope someone can explain this to me

Thanks

 

[SOS]

1. You could delete the tables in the MDB file and then import the tables from the MDE.

2. You should have this SPLIT so that it is a Frontend/Backend where the TABLES are in the backend (on the network) and the FRONTEND is a COPY on EACH user's machine.

You can then work on the frontend without having to worry about data.

Plus it is also the way that should be used for multiple users as the other way can cause corruption and you lose everything, data included.

 

[yus786]

1. You could delete the tables in the MDB file and then import the tables from the MDE.

2. You should have this SPLIT so that it is a Frontend/Backend where the TABLES are in the backend (on the network) and the FRONTEND is a COPY on EACH user's machine.

You can then work on the frontend without having to worry about data.

Plus it is also the way that should be used for multiple users as the other way can cause corruption and you lose everything, data included.

Thanks SOS

I wasn't aware of point 2 but it makes so much sense to have it this way. But could you please explain (or point me in the right direction) how this is done?

My DB is used by 5 users. The MDB is stored on a server and they all access this via mapped drives from their PC to this server.

So i really want to split it urgently

Thanks again

 

[SOS]

See here for that.

 

[yus786]

See here for that.

Thanks SOS

 

[yus786]

See here for that.

One more question. Any tips on how to secure the BE?

My FE has bespoke forms where userid and password needs to be entered, but this BE will just open up.

I tried to put a password on it but then the linked tables wont work.

Any tips please?

 

[dbDamo]

You need to remove the links to the tables, then password protect the back end, then link the tables again entering the password for the back end when prompted