making changes after deployment

[joeblow2]

Hi:
I recently split my application (myapplication.mdb) into
the database and the front-end. I put the database
(myapplication_be.mdb) in a shared folder.

I also made an mde (myapplication.mde) from
myapplication.mdb

My question is: how do I make changes to the database
table definitions? Because I obviously cannot use
myapplication.mdb or myapplication.mde as the database
is on it's own. Can I open myapplication_be.mdb with
Access and make the changes?

And my second question is that if I want to make changes
to the front-end, do I use myapplication.mde or
myapplication.mdb? My guess is that I should use
myapplication.mdb and then make a new mde to be deployed
to each of my users. Am I correct?

Thanks a lot!

 

[MSAccessRookie]

My question is: how do I make changes to the database table definitions? Because I obviously cannot use myapplication.mdb or myapplication.mde as the database is on it's own. Can I open myapplication_be.mdb with Access and make the changes?

If you are making changes to the structure of the database, (Adding/removing columns, changing column definitions, etc), then you should always use a copy of the BE as your linked tables. Once you have gotten it to work, you will need to port the data from the old format to the new format, making all necessary adjustments along the way.

Once this is done, you will have a new FE and BE with updated current data, which you can deploy as required.

And my second question is that if I want to make changes to the front-end, do I use myapplication.mde or myapplication.mdb? My guess is that I should use myapplication.mdb and then make a new mde to be deployed to each of my users. Am I correct?

You are correct. Use myapplication.mdb and then make a new mde to be deployed to each of your users once the changes have been implemented and tested.

 

[joeblow2]

Thanks a lot!!!!!!!