Re: The amazing disappearing VBA code

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Jun 2, 1:42 am, "Tony Toews [MVP]" <tto...@xxxxxxxxxxxxxxx> wrote:
"David W. Fenton" <XXXuse...@xxxxxxxxxxxxxxxxxxx> wrote:

Until the IT department changes the name of the server.  That's one of
the five reasons.  <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages -http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/
Granite Fleet Managerhttp://www.granitefleet.com/

And I've just been through that - it turned out we needed to keep both
servers online for an extended period after we installed a new server
- ugly all the way around.

And to get back to the topic at hand, I've just seen the problem the
original poster raised - on a complex Access front-end with lots of
VBA - and yes it is split, and deployed to each workstation - but this
happens to be the development copy! I'm hopeful that I have a good
backup from last night, but I can't restore it until tomorrow as the
server is some 800 miles from me and unattended outside normal working
hours. The environment is Windows Server 2008 with Access 2007 SP2.

I've heard others report this problem, but have not experienced it
myself until tonight. Something appears to be going on, and I see
several recent reports of it on other forums.

Wendell
.

Relevant Pages

  • Re: Update Mdb on the Fly (Forms, Reports, etc.)
    ... Doug Steele, Microsoft Access MVP ... (no e-mails, please!) ... Master_be.mdb file is on the departments server for all to use. ... change is made to a form or report. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Upload a file to the server
    ... They open the database to enter some details about this report(Word ... and you want the database to also hold a link to where the report ... Microsoft Access MVP ... file to the server like something of attachment in web mail. ...
    (microsoft.public.access.forms)
  • Re: microsoft excel 11,0 object library
    ... you should split the MDB into a Front End MDB containing the ... MDB which resides on a server. ... See the "Splitting your app into a front end and back end Tips" page ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access error on citrix environment only.
    ... Recently I migrated a MS Access app from mdb data tables to oracle db. ... citrix for only two screens with below error. ... Possibly the Citrix server has a different version of the Oracle driver software or ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: speeding up the performance of a split database
    ... >the server is across the complex centrally located. ... Tony Toews, Microsoft Access MVP ... Microsoft Access Links, Hints, Tips & Accounting Systems at ...
    (microsoft.public.access.formscoding)