How to update forms/code in an MDE split database?

[tony]

I have started supporting an Access application that has an MDE and split
database. I find that I can’t update forms or code in the front end of a
split database so I have to keep a copy of the database prior to splitting,
make my changes there, move individual forms, reports, or modules to the copy
of the Front End then finally recreate the new Font End MDE that I can copy
to workstations.

There must be an easier way. Can someone point me to a procedure for doing
this??

 

[John Spencer]

An mde is compiled and you can never update the forms and reports.
You must do as you are doing.

From your description, there is one thing I don't understand. WHY do
you feel you need to move the changes to a copy of the front end? Why
not just make an mde from the copy the database where you are making the
changes.

You might need to use some relinking code if your development copy is
linked to a test backend, but one version of the code for that is at

http://www.mvps.org/access/tables/tbl0009.htm

Or you can simply use the built-in tool to do the relinking before you
make the mde.

Menu: Tools: Database Utilities: Linked Table Manager

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[tony]

John,

Thank you for the response, and right now I feel foolish. I have tried
changing the MDB version of the front end and the design menu was grayed
out....

I tried it a couple more times with the same result so I did my convolute
and excessive work, works around….

I just tried it with the current version of my database and it worked
fine…..

I can live with that and use re-linking code to put it in production.

Your response made me go take another look. I’m not sure why it didn’t work
on my first tries but….. that is a non-issue since it is working now….

Tony

 

[Tony Toews [MVP]]

I new Font End MDE that I can copy
to workstations.

From another Tony.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

In a Terminal Server or Citrix environment the Auto FE Updater now
supports creating a directory named after the user on a server. Given
a choice put the FE on the Citrix server to reduce network traffic and
to avoid having to load objects over the network which can be somewhat
sluggish.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[tony]

Tony,


THANX!!!!! From what I read it looks GREAT. I will get a chance to play
with it next week.....

Tony

 

[Tony Toews [MVP]]

THANX!!!!! From what I read it looks GREAT.

You're welcome. It's a bit of a PITA to get it going the first time.
But once you have a simple case going you can add more functionality.

I will get a chance to play with it next week.....

Feel free to ask in this newsgroup, or the multi user newsgroup. Or
email me.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/