making changes after deployment 3

[joeblow3]

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!

 

[dhookom]

You should be able to open and make changes to the back-end if you have exclusive use. You can't change forms and/or reports in an MDE. You must change the mdb and then convert it to distribute to your users.

Duane
Hook'D on Access
MS Access MVP

 

[KornGeek]

You should never make the changes directly in the mde. Even if you are modifying a query (which can be done in an mde), you're better off doing it in the mdb and then creating a new mde. This way, you have a master source file (the mdb) that contains all of the changes.

 

[JBinQLD]

Don't forget to start using version numbers too so that you can be sure all users are using the same (most recent) front end!

Good luck,

JB

 

[KornGeek]

JB,

Great point!

Version numbers can save hours of tech support time simply because you know which version you're troubleshooting.