[AccessD] Access 2007 Failure to save design and code module changes.

Darryl Collins darryl at whittleconsulting.com.au
Tue Aug 9 18:37:59 CDT 2011


Thanks Darren,

Luckily I was only sitting at my own desk working on a project and not
showing a client.  That would be really awful.  And yeah, I got lucky as I
am really old school so I tend to zip up a copy of the database I am working
on every couple of hours (or less) as a backup - Too many times have I had
Access get corrupt and been saved by a backup version so it is pretty much
habit now.

Now, Here is where it gets odd.  The last zip back up of the database I was
working on has the changes, but in the latest version of the database they
are all missing.  How the hell can that happen??  It is not like I have even
taken a copy and mixed up which version I was working on.  The zip is just a
zipped up version of the current database taken a bit back in time.  

Now i am going to have to compare the last zipped backup with the current
version and try to bolt the changes together, or at least recall what the
changes that have been dropped were.  Bah.

Cheers
Darryl.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren - Active
Billing
Sent: Tuesday, 9 August 2011 11:01 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007 Failure to save design and code module
changes.

Hey Dazza from another Mother

Yes - I've had this - No, sorry, I don't have a solution for you. 
The first time I encountered this 'anomaly' was actually at a client's
office, whilst deploying (what I thought was) their new version.
The modified screens I had ploughed about 16 hours into over (what I thought
was) a very productive weekend, were just not there -Just not there. Yet
some 'new work' was.
I just assumed I had grabbed a backup made 'during' the process of the
modifications. And explained it as such to the client.
Then when I got back to the office the 'latest' version did not have my new
work changes either. Despite the Last modified date being 'about right'.
I could not work out what I had done. I was furious. And yes I saw some
mention of this stuff on the googaweb.

I'm not sure where the issue lies. I have a feeling (not confirmed) it's to
do with this new Vista and Win 7 file save feature.
The one that asks the following when you copy a file with the same name to
the same location...
"There is already a file with the same name in this location" 
Then you have the options of:  'Move and Replace' or 'Don't Move' or 'Move,
but keep both files'

So now, I work on a 'copy' of the real dB. I rename the copied dB, with the
new work with some silly name - Once complete I close all my work.
Then I open this new silly name dB, to make sure it actually has in it the
new or modified bits and pieces (tables, forms etc.)
And only then do I rename this new one back to the original name it should
be as per the client's version.
And even then I copy it and then put a copy on my dongle.
Then open the version on the dongle before I go to Client's to make
absolutely sure that the dongle version is indeed the correct version.

BTW - This happened to me a few times before I actually clicked that it
wasn't me (At least, I hope it wasn't me).

Sorry not much help - good luck.

D

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Tuesday, 9 August 2011 8:02 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access 2007 Failure to save design and code module
changes.


____________________________________________________________________________
___________

Note: This e-mail is subject to the disclaimer contained at the bottom of
this message.
____________________________________________________________________________
___________


GRRRR!!  What is it with A2007??  A quick google seems to suggest that
others have had similar issues, although no one seems to have a solution.

Has anyone else experience this?  You make changes in the VBE or a form or
form code and save (and save and save).  But the changes are just dropped -
nothing is saved.  In this instance none of the usual possible reason given
on google (database locked by other users, no write permission on the folder
blah blah are relevant).

It is one of the most *ANNOYING* bits of software I have had to misfortune
to use.  Anyone got any advice. I can't wait be done with it and move to
A2010.

cheers
Darryl
____________________________________________________________________________
___________

The information transmitted in this message and its attachments (if any) is
intended only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review,
retransmission, dissemination or other use of, or taking of any action in
reliance upon this information, by persons or entities other than the
intended recipient is prohibited.

If you have received this in error, please contact the sender and delete
this e-mail and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or
distribute the information contained in this e-mail and any attached files,
with the permission of the sender.

This message has been scanned for viruses.
____________________________________________________________________________
___________

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list