After splitting

hi,

After database splitting, would I be able to add more forms in the future?
Thanks!

--
Message posted via http://www.accessmonster.com

"accessuser via AccessMonster.com" u28669@uwe wrote in message
news:69a3fe677578e@uwe...
hi,

After database splitting, would I be able to add more forms in the future?
Thanks!

Certainly. Splitting (by itself) changes nothing about what further changes you
can make to either of the resulting files.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Tue, 21 Nov 2006 23:35:16 GMT, accessuser via AccessMonster.com
wrote:

hi,

After database splitting, would I be able to add more forms in the future?
Thanks!

Yes!
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Sorry i should have specified more information. I am thinking of making a
MDE (the one that nobody can use the design view and change the design) and
then split the MDE. From there, would I be able to add more forms in future?

thanks!

fredg wrote:
hi,

After database splitting, would I be able to add more forms in the future?
Thanks!

Yes!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200611/1

"accessuser via AccessMonster.com" u28669@uwe wrote in message
news:69a4b804b04ed@uwe...
Sorry i should have specified more information. I am thinking of making a
MDE (the one that nobody can use the design view and change the design) and
then split the MDE. From there, would I be able to add more forms in future?

No you cannot add forms to an MDE.

One of the main advantages to splitting is that there can be multiple front
ends. One of these is the MDB that you keep so you can continue to make
development changes. Then you use that to make a new MDE which you distribute
to your users.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Do you mean by split the Main database first into front and back end, and
then split the front end into MDE? How would the information carry over? So
in this way, I will be doing 2 database splits, is it right?

Rick Brandt wrote:
Sorry i should have specified more information. I am thinking of making a
MDE (the one that nobody can use the design view and change the design) and
then split the MDE. From there, would I be able to add more forms in future?

No you cannot add forms to an MDE.

One of the main advantages to splitting is that there can be multiple front
ends. One of these is the MDB that you keep so you can continue to make
development changes. Then you use that to make a new MDE which you distribute
to your users.


--
Message posted via http://www.accessmonster.com

"accessuser via AccessMonster.com" u28669@uwe wrote in message
news:69a51a2fc1be0@uwe...
Do you mean by split the Main database first into front and back end, and
then split the front end into MDE? How would the information carry over? So
in this way, I will be doing 2 database splits, is it right?

No. When you split you will have two MDBs. One with just tables and one with
everything else. When you are ready to deploy the app to users you use the MDB
containing forms, reports, code, etc., and you create an MDE from it. Now you
have three files, a back end MDB, a front end MDB and a front end MDE. You give
each user a copy of the MDE and you keep the front end MDB for further
development work.

While users are happily using the MDE you gave them you can continue to make
development changes to the front end MDB (new forms, reports, etc.). When you
have a new "version" to deploy you make a new MDE and send copies of that to
your users. Since the data is all stored in the back end MDB none of this makes
any difference to the data at all. Your users simply replace one MDE with a new
one and off they go.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thank you so much for your detail explaining!!!!

Rick Brandt wrote:
Do you mean by split the Main database first into front and back end, and
then split the front end into MDE? How would the information carry over? So
in this way, I will be doing 2 database splits, is it right?

No. When you split you will have two MDBs. One with just tables and one with
everything else. When you are ready to deploy the app to users you use the MDB
containing forms, reports, code, etc., and you create an MDE from it. Now you
have three files, a back end MDB, a front end MDB and a front end MDE. You give
each user a copy of the MDE and you keep the front end MDB for further
development work.

While users are happily using the MDE you gave them you can continue to make
development changes to the front end MDB (new forms, reports, etc.). When you
have a new "version" to deploy you make a new MDE and send copies of that to
your users. Since the data is all stored in the back end MDB none of this makes
any difference to the data at all. Your users simply replace one MDE with a new
one and off they go.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200611/1

"accessuser via AccessMonster.com" u28669@uwe wrote in
news:69a51a2fc1be0@uwe:

Do you mean by split the Main database first into front and back
end, and then split the front end into MDE? How would the
information carry over? So in this way, I will be doing 2
database splits, is it right?

Have you read the help file's definition of what an MDE is? It would
seem from your questions that you've omitted that basic and obvious
step.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/